Profiling Report

Dataset statistics

Number of variables	89
Number of observations	82255
Missing cells	4769225
Missing cells (%)	65.1%
Duplicate rows	7
Duplicate rows (%)	< 0.1%
Total size in memory	55.9 MiB
Average record size in memory	712.0 B

Variable types

Categorical	47
Numeric	22
Text	7
Unsupported	6
DateTime	7

Alerts

`oh_ClientCode` has constant value ""	Constant
`oh_OrderVoucherValue` has constant value ""	Constant
`oh_DeliveryTaxCode` has constant value ""	Constant
`oh_DeliveryReasonCode` has constant value ""	Constant
`oh_DiscountReasonCode` has constant value ""	Constant
`oh_LoyaltyValue` has constant value ""	Constant
`oh_OrderMethod` has constant value ""	Constant
`oh_Priority` has constant value ""	Constant
`oh_UserID` has constant value ""	Constant
`oh_CurrencyCode` has constant value ""	Constant
`oh_CurrencyRate` has constant value ""	Constant
`oh_ShippingReasonCode` has constant value ""	Constant
`oh_PII` has constant value ""	Constant
`ol_ClientCode` has constant value ""	Constant
`ol_PaymentMinorStatus` has constant value ""	Constant
`ol_ParentItemNumber` has constant value ""	Constant
`ol_Priority` has constant value ""	Constant
`ol_UserID` has constant value ""	Constant
`ol_CurrencyCode` has constant value ""	Constant
`ol_CurrencyRate` has constant value ""	Constant
`ol_DiscountReasonCode` has constant value ""	Constant
`ol_TaxLocale` has constant value ""	Constant
`ol_PII` has constant value ""	Constant
Dataset has 7 (< 0.1%) duplicate rows	Duplicates
`RTYPE` is highly overall correlated with `SYS_CHANGE_OPERATION` and 24 other fields	High correlation
`SYS_CHANGE_OPERATION` is highly overall correlated with `RTYPE` and 19 other fields	High correlation
`SYS_CHANGE_VERSION` is highly overall correlated with `ol_ShippingCode`	High correlation
`oh_CampaignCode` is highly overall correlated with `RTYPE` and 6 other fields	High correlation
`oh_CustomerID` is highly overall correlated with `ol_CustomerID` and 1 other fields	High correlation
`oh_DeliveryGrossValue` is highly overall correlated with `RTYPE` and 4 other fields	High correlation
`oh_DeliveryNetValue` is highly overall correlated with `RTYPE` and 4 other fields	High correlation
`oh_DeliveryTaxValue` is highly overall correlated with `RTYPE` and 4 other fields	High correlation
`oh_DiscountValue` is highly overall correlated with `ol_DiscountValue`	High correlation
`oh_LastActionCode` is highly overall correlated with `RTYPE` and 5 other fields	High correlation
`oh_NetOrderValue` is highly overall correlated with `oh_OrderGrossValue` and 3 other fields	High correlation
`oh_OrderGrossValue` is highly overall correlated with `oh_NetOrderValue` and 3 other fields	High correlation
`oh_OrderID` is highly overall correlated with `ol_InvoiceNumber` and 1 other fields	High correlation
`oh_OrderMajorStatus` is highly overall correlated with `RTYPE` and 6 other fields	High correlation
`oh_OrderMinorStatus` is highly overall correlated with `RTYPE` and 3 other fields	High correlation
`oh_OrderType` is highly overall correlated with `RTYPE` and 2 other fields	High correlation
`oh_OrderValuePaid` is highly overall correlated with `oh_NetOrderValue` and 3 other fields	High correlation
`oh_OrderValueRefunded` is highly overall correlated with `SYS_CHANGE_OPERATION` and 4 other fields	High correlation
`oh_PaymentMethod` is highly overall correlated with `RTYPE` and 7 other fields	High correlation
`oh_ShippingCode` is highly overall correlated with `RTYPE` and 9 other fields	High correlation
`oh_SourceCode` is highly overall correlated with `RTYPE` and 6 other fields	High correlation
`oh_TaxValue` is highly overall correlated with `oh_NetOrderValue` and 3 other fields	High correlation
`ol_AmountPaid` is highly overall correlated with `ol_AmountRefunded` and 7 other fields	High correlation
`ol_AmountRefunded` is highly overall correlated with `ol_AmountPaid` and 7 other fields	High correlation
`ol_CampaignCode` is highly overall correlated with `RTYPE` and 6 other fields	High correlation
`ol_CustomerID` is highly overall correlated with `oh_CustomerID` and 1 other fields	High correlation
`ol_DiscountValue` is highly overall correlated with `oh_DiscountValue`	High correlation
`ol_GrossValue` is highly overall correlated with `ol_AmountPaid` and 7 other fields	High correlation
`ol_InvoiceNumber` is highly overall correlated with `oh_OrderID` and 2 other fields	High correlation
`ol_ItemUnitPrice` is highly overall correlated with `ol_AmountPaid` and 7 other fields	High correlation
`ol_LastActionCode` is highly overall correlated with `RTYPE` and 5 other fields	High correlation
`ol_LineID` is highly overall correlated with `ol_ShippingCode`	High correlation
`ol_LineMajorStatus` is highly overall correlated with `RTYPE` and 9 other fields	High correlation
`ol_LineMinorStatus` is highly overall correlated with `RTYPE` and 8 other fields	High correlation
`ol_NetAmount` is highly overall correlated with `ol_AmountPaid` and 8 other fields	High correlation
`ol_OrderID` is highly overall correlated with `oh_OrderID` and 1 other fields	High correlation
`ol_PaymentMajorStatus` is highly overall correlated with `RTYPE` and 8 other fields	High correlation
`ol_PaymentMethod` is highly overall correlated with `RTYPE` and 7 other fields	High correlation
`ol_Quantity` is highly overall correlated with `RTYPE` and 3 other fields	High correlation
`ol_QuantityDespatched` is highly overall correlated with `ol_Quantity` and 1 other fields	High correlation
`ol_ShippingCode` is highly overall correlated with `RTYPE` and 17 other fields	High correlation
`ol_SkuStatus` is highly overall correlated with `RTYPE` and 8 other fields	High correlation
`ol_SkuStockStatus` is highly overall correlated with `RTYPE` and 7 other fields	High correlation
`ol_SourceCode` is highly overall correlated with `RTYPE` and 6 other fields	High correlation
`ol_TaxRate` is highly overall correlated with `RTYPE` and 2 other fields	High correlation
`ol_TaxValue` is highly overall correlated with `ol_AmountPaid` and 8 other fields	High correlation
`ol_Weight` is highly overall correlated with `RTYPE` and 7 other fields	High correlation
`RTYPE` is highly imbalanced (> 99.9%)	Imbalance
`oh_CampaignCode` is highly imbalanced (85.5%)	Imbalance
`oh_SourceCode` is highly imbalanced (67.1%)	Imbalance
`oh_PaymentMethod` is highly imbalanced (94.2%)	Imbalance
`oh_DeliveryNetValue` is highly imbalanced (75.5%)	Imbalance
`oh_DeliveryTaxValue` is highly imbalanced (72.0%)	Imbalance
`oh_DeliveryGrossValue` is highly imbalanced (71.9%)	Imbalance
`oh_OrderType` is highly imbalanced (92.3%)	Imbalance
`oh_OrderMajorStatus` is highly imbalanced (67.8%)	Imbalance
`oh_OrderMinorStatus` is highly imbalanced (97.3%)	Imbalance
`oh_LastActionCode` is highly imbalanced (79.9%)	Imbalance
`oh_ShippingCode` is highly imbalanced (51.7%)	Imbalance
`ol_CampaignCode` is highly imbalanced (85.5%)	Imbalance
`ol_SourceCode` is highly imbalanced (67.1%)	Imbalance
`ol_Quantity` is highly imbalanced (97.3%)	Imbalance
`ol_LineMajorStatus` is highly imbalanced (65.3%)	Imbalance
`ol_LineMinorStatus` is highly imbalanced (53.4%)	Imbalance
`ol_PaymentMethod` is highly imbalanced (94.2%)	Imbalance
`ol_TaxRate` is highly imbalanced (68.8%)	Imbalance
`SYS_CHANGE_VERSION` has 74064 (90.0%) missing values	Missing
`oh_OrderID` has 74064 (90.0%) missing values	Missing
`oh_CustomerID` has 74064 (90.0%) missing values	Missing
`oh_MediaID` has 82252 (> 99.9%) missing values	Missing
`oh_PaymentMethod` has 74064 (90.0%) missing values	Missing
`oh_PaymentType` has 82255 (100.0%) missing values	Missing
`oh_NetOrderValue` has 74064 (90.0%) missing values	Missing
`oh_TaxValue` has 74064 (90.0%) missing values	Missing
`oh_OrderGrossValue` has 74064 (90.0%) missing values	Missing
`oh_OrderValuePaid` has 74064 (90.0%) missing values	Missing
`oh_OrderValueRefunded` has 49491 (60.2%) missing values	Missing
`oh_OrderVoucherValue` has 49491 (60.2%) missing values	Missing
`oh_DeliveryTaxCode` has 49491 (60.2%) missing values	Missing
`oh_DeliveryNetValue` has 74064 (90.0%) missing values	Missing
`oh_DeliveryTaxValue` has 74064 (90.0%) missing values	Missing
`oh_DeliveryGrossValue` has 74064 (90.0%) missing values	Missing
`oh_DeliveryReasonCode` has 82254 (> 99.9%) missing values	Missing
`oh_DiscountValue` has 74064 (90.0%) missing values	Missing
`oh_DiscountReasonCode` has 71543 (87.0%) missing values	Missing
`oh_LoyaltyValue` has 74064 (90.0%) missing values	Missing
`oh_OrderMethod` has 74064 (90.0%) missing values	Missing
`oh_OrderType` has 74064 (90.0%) missing values	Missing
`oh_DespatchDate` has 82255 (100.0%) missing values	Missing
`oh_CancelledDate` has 82216 (> 99.9%) missing values	Missing
`oh_Priority` has 74064 (90.0%) missing values	Missing
`oh_UserID` has 74064 (90.0%) missing values	Missing
`oh_CurrencyCode` has 3734 (4.5%) missing values	Missing
`oh_CurrencyRate` has 74064 (90.0%) missing values	Missing
`oh_LastActionCode` has 79234 (96.3%) missing values	Missing
`oh_DueDate` has 3969 (4.8%) missing values	Missing
`oh_DeliverByDate` has 3969 (4.8%) missing values	Missing
`oh_ShippingReasonCode` has 82254 (> 99.9%) missing values	Missing
`ol_OrderID` has 74064 (90.0%) missing values	Missing
`ol_CustomerID` has 74064 (90.0%) missing values	Missing
`ol_LineID` has 74064 (90.0%) missing values	Missing
`ol_MediaID` has 82252 (> 99.9%) missing values	Missing
`ol_Quantity` has 74064 (90.0%) missing values	Missing
`ol_QuantityDespatched` has 74064 (90.0%) missing values	Missing
`ol_DespatchedDate` has 15965 (19.4%) missing values	Missing
`ol_LineMinorStatus` has 26934 (32.7%) missing values	Missing
`ol_SkuStatus` has 74064 (90.0%) missing values	Missing
`ol_SkuStockStatus` has 74064 (90.0%) missing values	Missing
`ol_PaymentMajorStatus` has 30576 (37.2%) missing values	Missing
`ol_PaymentMinorStatus` has 30577 (37.2%) missing values	Missing
`ol_PaymentMethod` has 74064 (90.0%) missing values	Missing
`ol_PaymentType` has 82255 (100.0%) missing values	Missing
`ol_CancelledDate` has 78136 (95.0%) missing values	Missing
`ol_LastActionCode` has 79709 (96.9%) missing values	Missing
`ol_ParentItemNumber` has 74064 (90.0%) missing values	Missing
`ol_Priority` has 74064 (90.0%) missing values	Missing
`ol_UserID` has 74064 (90.0%) missing values	Missing
`ol_CurrencyCode` has 3734 (4.5%) missing values	Missing
`ol_CurrencyRate` has 74064 (90.0%) missing values	Missing
`ol_ShippingCode` has 81996 (99.7%) missing values	Missing
`ol_InvoiceNumber` has 74064 (90.0%) missing values	Missing
`ol_ItemCostPrice` has 74064 (90.0%) missing values	Missing
`ol_ItemUnitPrice` has 74064 (90.0%) missing values	Missing
`ol_NetAmount` has 74064 (90.0%) missing values	Missing
`ol_TaxValue` has 74064 (90.0%) missing values	Missing
`ol_GrossValue` has 74064 (90.0%) missing values	Missing
`ol_AmountPaid` has 74064 (90.0%) missing values	Missing
`ol_AmountRefunded` has 78577 (95.5%) missing values	Missing
`ol_PostageValue` has 82255 (100.0%) missing values	Missing
`ol_PostageTaxValue` has 82255 (100.0%) missing values	Missing
`ol_PostageReasonCode` has 82255 (100.0%) missing values	Missing
`ol_DiscountValue` has 74064 (90.0%) missing values	Missing
`ol_DiscountReasonCode` has 81831 (99.5%) missing values	Missing
`ol_TaxLocale` has 82252 (> 99.9%) missing values	Missing
`ol_TaxRate` has 74064 (90.0%) missing values	Missing
`ol_Weight` has 74064 (90.0%) missing values	Missing
`ol_ItemCostPrice` is highly skewed (γ1 = 23.07598238)	Skewed
`oh_PaymentType` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`oh_DespatchDate` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ol_PaymentType` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ol_PostageValue` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ol_PostageTaxValue` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ol_PostageReasonCode` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`oh_OrderValueRefunded` has 24893 (30.3%) zeros	Zeros
`oh_DiscountValue` has 7411 (9.0%) zeros	Zeros
`ol_ItemCostPrice` has 8145 (9.9%) zeros	Zeros
`ol_ItemUnitPrice` has 2774 (3.4%) zeros	Zeros
`ol_NetAmount` has 2579 (3.1%) zeros	Zeros
`ol_TaxValue` has 3037 (3.7%) zeros	Zeros
`ol_GrossValue` has 2579 (3.1%) zeros	Zeros
`ol_AmountPaid` has 2631 (3.2%) zeros	Zeros
`ol_DiscountValue` has 7796 (9.5%) zeros	Zeros

Reproduction

Analysis started	2023-11-24 14:22:35.340067
Analysis finished	2023-11-24 14:24:18.131407
Duration	1 minute and 42.79 seconds
Software version	ydata-profiling vv4.6.2
Download configuration	config.json

RTYPE
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	642.7 KiB

H	82254
(82254 rows affected)	1

Length

Max length	21
Median length	1
Mean length	1.0002431
Min length	1

Characters and Unicode

Total characters	82275
Distinct characters	18
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	H
2nd row	H
3rd row	H
4th row	H
5th row	H

Common Values

Value	Count	Frequency (%)
H	82254	> 99.9%
(82254 rows affected)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
h	82254	> 99.9%
82254	1	< 0.1%
rows	1	< 0.1%
affected	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
H	82254	> 99.9%
2	2	< 0.1%
	2	< 0.1%
e	2	< 0.1%
f	2	< 0.1%
s	1	< 0.1%
d	1	< 0.1%
t	1	< 0.1%
c	1	< 0.1%
a	1	< 0.1%
Other values (8)	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	82254	> 99.9%
Lowercase Letter	12	< 0.1%
Decimal Number	5	< 0.1%
Space Separator	2	< 0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2	16.7%
f	2	16.7%
s	1	8.3%
d	1	8.3%
t	1	8.3%
c	1	8.3%
a	1	8.3%
w	1	8.3%
o	1	8.3%
r	1	8.3%

Decimal Number

Value	Count	Frequency (%)
2	2	40.0%
4	1	20.0%
5	1	20.0%
8	1	20.0%

Uppercase Letter

Value	Count	Frequency (%)
H	82254	100.0%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	82266	> 99.9%
Common	9	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
H	82254	> 99.9%
e	2	< 0.1%
f	2	< 0.1%
s	1	< 0.1%
d	1	< 0.1%
t	1	< 0.1%
c	1	< 0.1%
a	1	< 0.1%
w	1	< 0.1%
o	1	< 0.1%

Common

Value	Count	Frequency (%)
2	2	22.2%
	2	22.2%
(	1	11.1%
4	1	11.1%
5	1	11.1%
8	1	11.1%
)	1	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82275	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
H	82254	> 99.9%
2	2	< 0.1%
	2	< 0.1%
e	2	< 0.1%
f	2	< 0.1%
s	1	< 0.1%
d	1	< 0.1%
t	1	< 0.1%
c	1	< 0.1%
a	1	< 0.1%
Other values (8)	8	< 0.1%

SYS_CHANGE_VERSION
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	81
Distinct (%)	1.0%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	14184.347

Minimum	77
Maximum	26519
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	77
5-th percentile	947.5
Q1	8897
median	12122
Q3	22188
95-th percentile	25267
Maximum	26519
Range	26442
Interquartile range (IQR)	13291

Descriptive statistics

Standard deviation	7666.6463
Coefficient of variation (CV)	0.54050048
Kurtosis	-1.1874222
Mean	14184.347
Median Absolute Deviation (MAD)	5952
Skewness	0.065546675
Sum	1.1618398 × 10⁸
Variance	58777465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8897	620	0.8%
11378	542	0.7%
10602	536	0.7%
7674	507	0.6%
22995	454	0.6%
9615	425	0.5%
25267	417	0.5%
12122	401	0.5%
77	400	0.5%
21227	385	0.5%
Other values (71)	3504	4.3%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
77	400	0.5%
211	4	< 0.1%
853	6	< 0.1%
1042	136	0.2%
1425	30	< 0.1%
1835	10	< 0.1%
2440	9	< 0.1%
3009	3	< 0.1%
4053	2	< 0.1%
5928	157	0.2%

Value	Count	Frequency (%)
26519	3	< 0.1%
26480	4	< 0.1%
26469	3	< 0.1%
26426	4	< 0.1%
26423	2	< 0.1%
26401	95	0.1%
26399	17	< 0.1%
25882	6	< 0.1%
25864	209	0.3%
25746	6	< 0.1%

SYS_CHANGE_OPERATION
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

U	41408
I	40846

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	82254
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	U
2nd row	U
3rd row	U
4th row	U
5th row	U

Common Values

Value	Count	Frequency (%)
U	41408	50.3%
I	40846	49.7%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
u	41408	50.3%
i	40846	49.7%

Most occurring characters

Value	Count	Frequency (%)
U	41408	50.3%
I	40846	49.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	82254	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
U	41408	50.3%
I	40846	49.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	82254	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	41408	50.3%
I	40846	49.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82254	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	41408	50.3%
I	40846	49.7%

oh_ClientCode
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

CRW	82254

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	246762
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CRW
2nd row	CRW
3rd row	CRW
4th row	CRW
5th row	CRW

Common Values

Value	Count	Frequency (%)
CRW	82254	> 99.9%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
crw	82254	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	246762	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	246762	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	246762	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

oh_OrderID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2113
Distinct (%)	25.8%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	6519444.4

Minimum	5421459
Maximum	6555985
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	5421459
5-th percentile	6471496
Q1	6512281.5
median	6525779
Q3	6537162
95-th percentile	6550271.5
Maximum	6555985
Range	1134526
Interquartile range (IQR)	24880.5

Descriptive statistics

Standard deviation	41613.862
Coefficient of variation (CV)	0.0063830381
Kurtosis	191.72675
Mean	6519444.4
Median Absolute Deviation (MAD)	12142
Skewness	-10.705328
Sum	5.3400769 × 10¹⁰
Variance	1.7317135 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6514411	25	< 0.1%
6489908	19	< 0.1%
6552899	18	< 0.1%
6541399	17	< 0.1%
6474533	16	< 0.1%
6533665	15	< 0.1%
6522805	15	< 0.1%
6533159	14	< 0.1%
6482742	14	< 0.1%
6542958	14	< 0.1%
Other values (2103)	8024	9.8%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5421459	2	< 0.1%
5864333	2	< 0.1%
5942595	4	< 0.1%
5983878	7	< 0.1%
6048975	4	< 0.1%
6081160	4	< 0.1%
6111623	4	< 0.1%
6334792	2	< 0.1%
6344916	4	< 0.1%
6345788	3	< 0.1%

Value	Count	Frequency (%)
6555985	1	< 0.1%
6555965	9	< 0.1%
6555919	2	< 0.1%
6555892	9	< 0.1%
6555809	2	< 0.1%
6555777	3	< 0.1%
6555770	3	< 0.1%
6555726	2	< 0.1%
6555724	2	< 0.1%
6555650	6	< 0.1%

oh_ExternalOrderID
Text

Distinct	23772
Distinct (%)	29.0%
Missing	339
Missing (%)	0.4%
Memory size	642.7 KiB

Length

Max length	16
Median length	8
Mean length	8.1055471
Min length	5

Characters and Unicode

Total characters	663974
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2494 ?
Unique (%)	3.0%

Sample

1st row	12841488
2nd row	12841488
3rd row	13158853
4th row	13158853
5th row	13217192

Value	Count	Frequency (%)
13715808	32	< 0.1%
13660449	25	< 0.1%
13719960	24	< 0.1%
13710909	23	< 0.1%
13707110	23	< 0.1%
13666197	21	< 0.1%
13714759	20	< 0.1%
13719757	20	< 0.1%
13708042	20	< 0.1%
13704457	20	< 0.1%
Other values (23762)	81688	99.7%

Most occurring characters

Value	Count	Frequency (%)
1	147525	22.2%
3	119543	18.0%
7	103507	15.6%
0	69125	10.4%
6	44337	6.7%
2	36135	5.4%
8	35524	5.4%
9	35514	5.3%
4	33863	5.1%
5	33859	5.1%
Other values (9)	5042	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	658932	99.2%
Uppercase Letter	4716	0.7%
Dash Punctuation	326	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	147525	22.4%
3	119543	18.1%
7	103507	15.7%
0	69125	10.5%
6	44337	6.7%
2	36135	5.5%
8	35524	5.4%
9	35514	5.4%
4	33863	5.1%
5	33859	5.1%

Uppercase Letter

Value	Count	Frequency (%)
Y	3889	82.5%
V	163	3.5%
E	163	3.5%
R	163	3.5%
O	163	3.5%
S	114	2.4%
M	49	1.0%
X	12	0.3%

Dash Punctuation

Value	Count	Frequency (%)
-	326	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	659258	99.3%
Latin	4716	0.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	147525	22.4%
3	119543	18.1%
7	103507	15.7%
0	69125	10.5%
6	44337	6.7%
2	36135	5.5%
8	35524	5.4%
9	35514	5.4%
4	33863	5.1%
5	33859	5.1%

Latin

Value	Count	Frequency (%)
Y	3889	82.5%
V	163	3.5%
E	163	3.5%
R	163	3.5%
O	163	3.5%
S	114	2.4%
M	49	1.0%
X	12	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	663974	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	147525	22.2%
3	119543	18.0%
7	103507	15.6%
0	69125	10.4%
6	44337	6.7%
2	36135	5.4%
8	35524	5.4%
9	35514	5.3%
4	33863	5.1%
5	33859	5.1%
Other values (9)	5042	0.8%

oh_CustomerID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2037
Distinct (%)	24.9%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	24851252

Minimum	10512
Maximum	34101675
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	10512
5-th percentile	9959870
Q1	17903003
median	25847047
Q3	33849878
95-th percentile	34033050
Maximum	34101675
Range	34091163
Interquartile range (IQR)	15946875

Descriptive statistics

Standard deviation	8493903.9
Coefficient of variation (CV)	0.34178978
Kurtosis	-0.9286762
Mean	24851252
Median Absolute Deviation (MAD)	7998564
Skewness	-0.46525263
Sum	2.035566 × 10¹¹
Variance	7.2146403 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16635245	26	< 0.1%
10425049	25	< 0.1%
15614761	24	< 0.1%
33836149	19	< 0.1%
34087130	18	< 0.1%
17181934	17	< 0.1%
33912221	17	< 0.1%
17162728	16	< 0.1%
33779356	16	< 0.1%
34009472	15	< 0.1%
Other values (2027)	7998	9.7%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10512	7	< 0.1%
494757	3	< 0.1%
691469	3	< 0.1%
989806	3	< 0.1%
1848530	3	< 0.1%
3014983	4	< 0.1%
3396223	3	< 0.1%
3767001	3	< 0.1%
3799000	6	< 0.1%
3809340	7	< 0.1%

Value	Count	Frequency (%)
34101675	1	< 0.1%
34101451	2	< 0.1%
34100990	2	< 0.1%
34100123	6	< 0.1%
34100040	4	< 0.1%
34099788	2	< 0.1%
34099705	2	< 0.1%
34097493	3	< 0.1%
34096024	3	< 0.1%
34095323	4	< 0.1%

oh_CampaignCode
Categorical

HIGH CORRELATION IMBALANCE

Distinct	11
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

WEBT	76301
JLP	3726
WEBC	1084
UKMO	355
GLBE	308
Other values (6)	480

Length

Max length	4
Median length	4
Mean length	3.9545919
Min length	2

Characters and Unicode

Total characters	325281
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	WEBT
2nd row	WEBT
3rd row	WEBT
4th row	WEBT
5th row	WEBT

Common Values

Value	Count	Frequency (%)
WEBT	76301	92.8%
JLP	3726	4.5%
WEBC	1084	1.3%
UKMO	355	0.4%
GLBE	308	0.4%
GIFT	234	0.3%
VERY	163	0.2%
NXPP	76	0.1%
CAT	4	< 0.1%
MO	2	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
webt	76301	92.8%
jlp	3726	4.5%
webc	1084	1.3%
ukmo	355	0.4%
glbe	308	0.4%
gift	234	0.3%
very	163	0.2%
nxpp	76	0.1%
cat	4	< 0.1%
mo	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	325281	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	325281	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	325281	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

oh_SourceCode
Categorical

HIGH CORRELATION IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

WEB	64871
CLIC	7538
AW	5851
JLP	3726
VERY	163
Other values (5)	105

Length

Max length	10
Median length	3
Mean length	3.0245702
Min length	2

Characters and Unicode

Total characters	248783
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WEB
2nd row	WEB
3rd row	WEB
4th row	WEB
5th row	WEB

Common Values

Value	Count	Frequency (%)
WEB	64871	78.9%
CLIC	7538	9.2%
AW	5851	7.1%
JLP	3726	4.5%
VERY	163	0.2%
NXPP	76	0.1%
AWSRC=AW	13	< 0.1%
AT01	9	< 0.1%
CAT	4	< 0.1%
MAIL ORDER	3	< 0.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
web	64871	78.9%
clic	7538	9.2%
aw	5851	7.1%
jlp	3726	4.5%
very	163	0.2%
nxpp	76	0.1%
awsrc=aw	13	< 0.1%
at01	9	< 0.1%
cat	4	< 0.1%
mail	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (13)	547	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	248749	> 99.9%
Decimal Number	18	< 0.1%
Math Symbol	13	< 0.1%
Space Separator	3	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (9)	513	0.2%

Decimal Number

Value	Count	Frequency (%)
0	9	50.0%
1	9	50.0%

Math Symbol

Value	Count	Frequency (%)
=	13	100.0%

Space Separator

Value	Count	Frequency (%)
	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	248749	> 99.9%
Common	34	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (9)	513	0.2%

Common

Value	Count	Frequency (%)
=	13	38.2%
0	9	26.5%
1	9	26.5%
	3	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	248783	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (13)	547	0.2%

oh_MediaID
Text

MISSING

Distinct	2
Distinct (%)	66.7%
Missing	82252
Missing (%)	> 99.9%
Memory size	642.7 KiB

Length

Max length	20
Median length	11
Mean length	14
Min length	11

Characters and Unicode

Total characters	42
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	33.3%

Sample

1st row	PHONE Order
2nd row	PHONE Order
3rd row	Verifone PHONE Order

Value	Count	Frequency (%)
phone	3	42.9%
order	3	42.9%
verifone	1	14.3%

Most occurring characters

Value	Count	Frequency (%)
r	7	16.7%
O	6	14.3%
e	5	11.9%
	4	9.5%
P	3	7.1%
H	3	7.1%
N	3	7.1%
E	3	7.1%
d	3	7.1%
V	1	2.4%
Other values (4)	4	9.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19	45.2%
Uppercase Letter	19	45.2%
Space Separator	4	9.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	7	36.8%
e	5	26.3%
d	3	15.8%
i	1	5.3%
f	1	5.3%
o	1	5.3%
n	1	5.3%

Uppercase Letter

Value	Count	Frequency (%)
O	6	31.6%
P	3	15.8%
H	3	15.8%
N	3	15.8%
E	3	15.8%
V	1	5.3%

Space Separator

Value	Count	Frequency (%)
	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	38	90.5%
Common	4	9.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	7	18.4%
O	6	15.8%
e	5	13.2%
P	3	7.9%
H	3	7.9%
N	3	7.9%
E	3	7.9%
d	3	7.9%
V	1	2.6%
i	1	2.6%
Other values (3)	3	7.9%

Common

Value	Count	Frequency (%)
	4	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	7	16.7%
O	6	14.3%
e	5	11.9%
	4	9.5%
P	3	7.1%
H	3	7.1%
N	3	7.1%
E	3	7.1%
d	3	7.1%
V	1	2.4%
Other values (4)	4	9.5%

oh_PaymentMethod
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

2.0	8107
4.0	45
1.0	39

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	2.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	8107	9.9%
4.0	45	0.1%
1.0	39	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	8107	99.0%
4.0	45	0.5%
1.0	39	0.5%

Most occurring characters

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
2	8107	33.0%
4	45	0.2%
1	39	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	8191	50.0%
2	8107	49.5%
4	45	0.3%
1	39	0.2%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
2	8107	33.0%
4	45	0.2%
1	39	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
2	8107	33.0%
4	45	0.2%
1	39	0.2%

oh_PaymentType
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	82255
Missing (%)	100.0%
Memory size	642.7 KiB

oh_NetOrderValue
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1046
Distinct (%)	12.8%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	126.17569

Minimum	0
Maximum	1081.39
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	34.55
Q1	58.76
median	93.76
Q3	153.13
95-th percentile	314.42
Maximum	1081.39
Range	1081.39
Interquartile range (IQR)	94.37

Descriptive statistics

Standard deviation	109.16417
Coefficient of variation (CV)	0.86517591
Kurtosis	19.982003
Mean	126.17569
Median Absolute Deviation (MAD)	42.96
Skewness	3.3985993
Sum	1033505.1
Variance	11916.815
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73.76	158	0.2%
81.26	115	0.1%
43.13	87	0.1%
46.88	86	0.1%
40.17	75	0.1%
43.92	66	0.1%
43.75	60	0.1%
36.88	58	0.1%
77.51	56	0.1%
75	48	0.1%
Other values (1036)	7382	9.0%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
9.17	2	< 0.1%
10	2	< 0.1%
11.25	4	< 0.1%
11.67	2	< 0.1%
13	2	< 0.1%
13.29	4	< 0.1%
13.33	2	< 0.1%
13.75	2	< 0.1%
14.54	3	< 0.1%

Value	Count	Frequency (%)
1081.39	25	< 0.1%
641.03	19	< 0.1%
628.94	17	< 0.1%
584.97	11	< 0.1%
568.16	8	< 0.1%
552.52	12	< 0.1%
500.06	15	< 0.1%
461.66	10	< 0.1%
455.04	11	< 0.1%
451.5	15	< 0.1%

oh_TaxValue
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	889
Distinct (%)	10.9%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.466875

Minimum	0
Maximum	216.34
Zeros	318
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2.71
Q1	10
median	17.38
Q3	29.48
95-th percentile	61.5
Maximum	216.34
Range	216.34
Interquartile range (IQR)	19.48

Descriptive statistics

Standard deviation	21.583085
Coefficient of variation (CV)	0.91972559
Kurtosis	20.992706
Mean	23.466875
Median Absolute Deviation (MAD)	8.6
Skewness	3.3963228
Sum	192217.17
Variance	465.82956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	318	0.4%
14.74	163	0.2%
16.24	115	0.1%
9.37	104	0.1%
8.62	87	0.1%
7.37	78	0.1%
8.03	75	0.1%
8.78	66	0.1%
8.75	64	0.1%
8.12	62	0.1%
Other values (879)	7059	8.6%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	318	0.4%
0.66	46	0.1%
0.99	18	< 0.1%
1.5	5	< 0.1%
1.83	2	< 0.1%
2	2	< 0.1%
2.25	9	< 0.1%
2.33	2	< 0.1%
2.6	2	< 0.1%
2.66	4	< 0.1%

Value	Count	Frequency (%)
216.34	25	< 0.1%
125.71	17	< 0.1%
116.98	11	< 0.1%
113.59	8	< 0.1%
110.48	12	< 0.1%
99.94	15	< 0.1%
93.47	19	< 0.1%
92.34	10	< 0.1%
90.96	11	< 0.1%
90.03	14	< 0.1%

oh_OrderGrossValue
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	870
Distinct (%)	10.6%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	149.64256

Minimum	0
Maximum	1297.73
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	41.3
Q1	68.25
median	111.5
Q3	180.6
95-th percentile	377.25
Maximum	1297.73
Range	1297.73
Interquartile range (IQR)	112.35

Descriptive statistics

Standard deviation	129.6657
Coefficient of variation (CV)	0.86650279
Kurtosis	20.718261
Mean	149.64256
Median Absolute Deviation (MAD)	51.5
Skewness	3.4442517
Sum	1225722.2
Variance	16813.193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88.5	161	0.2%
97.5	119	0.1%
51.75	90	0.1%
56.25	89	0.1%
48.2	75	0.1%
52.7	66	0.1%
52.5	64	0.1%
93	60	0.1%
44.25	60	0.1%
90	57	0.1%
Other values (860)	7350	8.9%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
11	2	< 0.1%
12	2	< 0.1%
13.5	4	< 0.1%
14	2	< 0.1%
15.4	2	< 0.1%
15.6	2	< 0.1%
15.95	4	< 0.1%
16	2	< 0.1%
16.5	2	< 0.1%

Value	Count	Frequency (%)
1297.73	25	< 0.1%
754.65	17	< 0.1%
734.5	19	< 0.1%
701.95	11	< 0.1%
681.75	8	< 0.1%
663	12	< 0.1%
600	15	< 0.1%
554	10	< 0.1%
546	11	< 0.1%
540.55	14	< 0.1%

oh_OrderValuePaid
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	862
Distinct (%)	10.5%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	148.97502

Minimum	0
Maximum	1297.73
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	41.3
Q1	67.6
median	111
Q3	180.25
95-th percentile	376.5
Maximum	1297.73
Range	1297.73
Interquartile range (IQR)	112.65

Descriptive statistics

Standard deviation	128.57651
Coefficient of variation (CV)	0.86307426
Kurtosis	21.060107
Mean	148.97502
Median Absolute Deviation (MAD)	51.75
Skewness	3.4459595
Sum	1220254.4
Variance	16531.918
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88.5	161	0.2%
97.5	119	0.1%
51.75	90	0.1%
56.25	89	0.1%
48.2	75	0.1%
52.5	67	0.1%
52.7	66	0.1%
90	63	0.1%
44.25	63	0.1%
93	60	0.1%
Other values (852)	7338	8.9%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
11	2	< 0.1%
12	2	< 0.1%
13.5	4	< 0.1%
14	2	< 0.1%
15.4	2	< 0.1%
15.6	2	< 0.1%
15.95	4	< 0.1%
16	2	< 0.1%
16.5	2	< 0.1%

Value	Count	Frequency (%)
1297.73	25	< 0.1%
734.5	19	< 0.1%
687.15	17	< 0.1%
681.75	8	< 0.1%
663	12	< 0.1%
657.7	11	< 0.1%
600	15	< 0.1%
554	10	< 0.1%
546	11	< 0.1%
540.55	14	< 0.1%

oh_OrderValueRefunded
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	575
Distinct (%)	1.8%
Missing	49491
Missing (%)	60.2%
Infinite	0
Infinite (%)	0.0%
Mean	23.85897

Minimum	0
Maximum	1097.59
Zeros	24893
Zeros (%)	30.3%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	133.5
Maximum	1097.59
Range	1097.59
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	64.729386
Coefficient of variation (CV)	2.7130001
Kurtosis	70.815014
Mean	23.85897
Median Absolute Deviation (MAD)	0
Skewness	6.3172168
Sum	781715.28
Variance	4189.8934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	24893	30.3%
44.25	416	0.5%
48.75	321	0.4%
56.25	161	0.2%
51.75	157	0.2%
45.5	136	0.2%
41.3	130	0.2%
88.5	122	0.1%
48.3	118	0.1%
97.5	97	0.1%
Other values (565)	6213	7.6%
(Missing)	49491	60.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	24893	30.3%
3.95	3	< 0.1%
5.95	3	< 0.1%
8	7	< 0.1%
11	5	< 0.1%
11.2	6	< 0.1%
11.25	3	< 0.1%
12	13	< 0.1%
13	3	< 0.1%
13.25	2	< 0.1%

Value	Count	Frequency (%)
1097.59	25	< 0.1%
623.76	12	< 0.1%
586.5	19	< 0.1%
507	5	< 0.1%
480.75	13	< 0.1%
461.3	14	< 0.1%
457.5	11	< 0.1%
411	9	< 0.1%
388.31	7	< 0.1%
385.68	16	< 0.1%

oh_OrderVoucherValue
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	49491
Missing (%)	60.2%
Memory size	642.7 KiB

0.0	32764

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	98292
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	32764	39.8%
(Missing)	49491	60.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	32764	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	65528	66.7%
.	32764	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	65528	66.7%
Other Punctuation	32764	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	65528	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	32764	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	98292	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	65528	66.7%
.	32764	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	98292	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	65528	66.7%
.	32764	33.3%

oh_DeliveryTaxCode
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	49491
Missing (%)	60.2%
Memory size	642.7 KiB

0.0	32764

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	98292
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	32764	39.8%
(Missing)	49491	60.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	32764	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	65528	66.7%
.	32764	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	65528	66.7%
Other Punctuation	32764	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	65528	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	32764	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	98292	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	65528	66.7%
.	32764	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	98292	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	65528	66.7%
.	32764	33.3%

oh_DeliveryNetValue
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	5
Distinct (%)	0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	7409
3.29	461
4.96	290
2.92	25
3.95	6

Length

Max length	4
Median length	3
Mean length	3.0954706
Min length	3

Characters and Unicode

Total characters	25355
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	7409	9.0%
3.29	461	0.6%
4.96	290	0.4%
2.92	25	< 0.1%
3.95	6	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	7409	90.5%
3.29	461	5.6%
4.96	290	3.5%
2.92	25	0.3%
3.95	6	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	14818	58.4%
.	8191	32.3%
9	782	3.1%
2	511	2.0%
3	467	1.8%
4	290	1.1%
6	290	1.1%
5	6	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17164	67.7%
Other Punctuation	8191	32.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	14818	86.3%
9	782	4.6%
2	511	3.0%
3	467	2.7%
4	290	1.7%
6	290	1.7%
5	6	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25355	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	14818	58.4%
.	8191	32.3%
9	782	3.1%
2	511	2.0%
3	467	1.8%
4	290	1.1%
6	290	1.1%
5	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25355	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14818	58.4%
.	8191	32.3%
9	782	3.1%
2	511	2.0%
3	467	1.8%
4	290	1.1%
6	290	1.1%
5	6	< 0.1%

oh_DeliveryTaxValue
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	7415
0.66	461
0.99	290
0.58	25

Length

Max length	4
Median length	3
Mean length	3.0947381
Min length	3

Characters and Unicode

Total characters	25349
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	7415	9.0%
0.66	461	0.6%
0.99	290	0.4%
0.58	25	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	7415	90.5%
0.66	461	5.6%
0.99	290	3.5%
0.58	25	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	15606	61.6%
.	8191	32.3%
6	922	3.6%
9	580	2.3%
5	25	0.1%
8	25	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17158	67.7%
Other Punctuation	8191	32.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15606	91.0%
6	922	5.4%
9	580	3.4%
5	25	0.1%
8	25	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25349	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	15606	61.6%
.	8191	32.3%
6	922	3.6%
9	580	2.3%
5	25	0.1%
8	25	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25349	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	15606	61.6%
.	8191	32.3%
6	922	3.6%
9	580	2.3%
5	25	0.1%
8	25	0.1%

oh_DeliveryGrossValue
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	7409
3.95	467
5.95	290
3.5	25

Length

Max length	4
Median length	3
Mean length	3.0924185
Min length	3

Characters and Unicode

Total characters	25330
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	7409	9.0%
3.95	467	0.6%
5.95	290	0.4%
3.5	25	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	7409	90.5%
3.95	467	5.7%
5.95	290	3.5%
3.5	25	0.3%

Most occurring characters

Value	Count	Frequency (%)
0	14818	58.5%
.	8191	32.3%
5	1072	4.2%
9	757	3.0%
3	492	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17139	67.7%
Other Punctuation	8191	32.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	14818	86.5%
5	1072	6.3%
9	757	4.4%
3	492	2.9%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25330	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	14818	58.5%
.	8191	32.3%
5	1072	4.2%
9	757	3.0%
3	492	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25330	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14818	58.5%
.	8191	32.3%
5	1072	4.2%
9	757	3.0%
3	492	1.9%

oh_DeliveryReasonCode
Text

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	82254
Missing (%)	> 99.9%
Memory size	642.7 KiB

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	4
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	LD L

Value	Count	Frequency (%)
ld	1	50.0%
l	1	50.0%

Most occurring characters

Value	Count	Frequency (%)
L	2	50.0%
D	1	25.0%
	1	25.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3	75.0%
Space Separator	1	25.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	2	66.7%
D	1	33.3%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3	75.0%
Common	1	25.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	2	66.7%
D	1	33.3%

Common

Value	Count	Frequency (%)
	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	2	50.0%
D	1	25.0%
	1	25.0%

oh_DiscountValue
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	113
Distinct (%)	1.4%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0475534

Minimum	0
Maximum	175.05
Zeros	7411
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	20.85
Maximum	175.05
Range	175.05
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	14.204934
Coefficient of variation (CV)	4.6610943
Kurtosis	74.936634
Mean	3.0475534
Median Absolute Deviation (MAD)	0
Skewness	7.7088354
Sum	24962.51
Variance	201.78014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7411	9.0%
25	52	0.1%
9.75	28	< 0.1%
175.05	25	< 0.1%
40	25	< 0.1%
35	22	< 0.1%
28	19	< 0.1%
15	18	< 0.1%
86.3	16	< 0.1%
10	15	< 0.1%
Other values (103)	560	0.7%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7411	9.0%
1.69	5	< 0.1%
1.75	3	< 0.1%
1.92	4	< 0.1%
2.21	2	< 0.1%
2.7	5	< 0.1%
2.81	4	< 0.1%
3.12	3	< 0.1%
3.56	4	< 0.1%
3.69	3	< 0.1%

Value	Count	Frequency (%)
175.05	25	< 0.1%
105	9	< 0.1%
100.6	8	< 0.1%
90	5	< 0.1%
86.3	16	< 0.1%
80.5	9	< 0.1%
80	5	< 0.1%
72.25	4	< 0.1%
66.8	4	< 0.1%
63.2	12	< 0.1%

oh_DiscountReasonCode
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	71543
Missing (%)	87.0%
Memory size	642.7 KiB

PGR	10712

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	32136
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PGR
2nd row	PGR
3rd row	PGR
4th row	PGR
5th row	PGR

Common Values

Value	Count	Frequency (%)
PGR	10712	13.0%
(Missing)	71543	87.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pgr	10712	100.0%

Most occurring characters

Value	Count	Frequency (%)
P	10712	33.3%
G	10712	33.3%
R	10712	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	32136	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	10712	33.3%
G	10712	33.3%
R	10712	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	32136	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	10712	33.3%
G	10712	33.3%
R	10712	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32136	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	10712	33.3%
G	10712	33.3%
R	10712	33.3%

oh_LoyaltyValue
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	8191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16382	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

oh_OrderMethod
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

5.0	8191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
5	8191	33.3%
.	8191	33.3%
0	8191	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	8191	50.0%
0	8191	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	8191	33.3%
.	8191	33.3%
0	8191	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	8191	33.3%
.	8191	33.3%
0	8191	33.3%

oh_OrderType
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	8114
2.0	77

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	8114	9.9%
2.0	77	0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	8114	99.1%
2.0	77	0.9%

Most occurring characters

Value	Count	Frequency (%)
0	16305	66.4%
.	8191	33.3%
2	77	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16305	99.5%
2	77	0.5%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16305	66.4%
.	8191	33.3%
2	77	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16305	66.4%
.	8191	33.3%
2	77	0.3%

oh_OrderMajorStatus
Categorical

HIGH CORRELATION IMBALANCE

Distinct	7
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

Despatch Confirmed	65082
Ready For Despatch	14518
Partialy Despatched	2124
Partialy Held	238
Picking at Store	166
Other values (2)	126

Length

Max length	19
Median length	18
Mean length	17.994237
Min length	9

Characters and Unicode

Total characters	1480098
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Despatch Confirmed
2nd row	Despatch Confirmed
3rd row	Despatch Confirmed
4th row	Despatch Confirmed
5th row	Despatch Confirmed

Common Values

Value	Count	Frequency (%)
Despatch Confirmed	65082	79.1%
Ready For Despatch	14518	17.6%
Partialy Despatched	2124	2.6%
Partialy Held	238	0.3%
Picking at Store	166	0.2%
Cancelled	68	0.1%
Held Order	58	0.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
despatch	79600	44.4%
confirmed	65082	36.3%
ready	14518	8.1%
for	14518	8.1%
partialy	2362	1.3%
despatched	2124	1.2%
held	296	0.2%
picking	166	0.1%
at	166	0.1%
store	166	0.1%
Other values (2)	126	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	164104	11.1%
a	101200	6.8%
	96870	6.5%
t	84418	5.7%
r	82244	5.6%
d	82146	5.6%
c	81958	5.5%
D	81724	5.5%
s	81724	5.5%
p	81724	5.5%
Other values (17)	541986	36.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1204270	81.4%
Uppercase Letter	178958	12.1%
Space Separator	96870	6.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	164104	13.6%
a	101200	8.4%
t	84418	7.0%
r	82244	6.8%
d	82146	6.8%
c	81958	6.8%
s	81724	6.8%
p	81724	6.8%
h	81724	6.8%
o	79766	6.6%
Other values (8)	283262	23.5%

Uppercase Letter

Value	Count	Frequency (%)
D	81724	45.7%
C	65150	36.4%
R	14518	8.1%
F	14518	8.1%
P	2528	1.4%
H	296	0.2%
S	166	0.1%
O	58	< 0.1%

Space Separator

Value	Count	Frequency (%)
	96870	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1383228	93.5%
Common	96870	6.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	164104	11.9%
a	101200	7.3%
t	84418	6.1%
r	82244	5.9%
d	82146	5.9%
c	81958	5.9%
D	81724	5.9%
s	81724	5.9%
p	81724	5.9%
h	81724	5.9%
Other values (16)	460262	33.3%

Common

Value	Count	Frequency (%)
	96870	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1480098	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	164104	11.1%
a	101200	6.8%
	96870	6.5%
t	84418	5.7%
r	82244	5.6%
d	82146	5.6%
c	81958	5.5%
D	81724	5.5%
s	81724	5.5%
p	81724	5.5%
Other values (17)	541986	36.6%

oh_OrderMinorStatus
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

None	81878
Stock Control	358
Duplicate Order	18

Length

Max length	15
Median length	4
Mean length	4.0415785
Min length	4

Characters and Unicode

Total characters	332436
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	81878	99.5%
Stock Control	358	0.4%
Duplicate Order	18	< 0.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
none	81878	99.1%
stock	358	0.4%
control	358	0.4%
duplicate	18	< 0.1%
order	18	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	82952	25.0%
n	82236	24.7%
e	81914	24.6%
N	81878	24.6%
t	734	0.2%
r	394	0.1%
l	376	0.1%
c	376	0.1%
	376	0.1%
C	358	0.1%
Other values (9)	842	0.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	249430	75.0%
Uppercase Letter	82630	24.9%
Space Separator	376	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	82952	33.3%
n	82236	33.0%
e	81914	32.8%
t	734	0.3%
r	394	0.2%
l	376	0.2%
c	376	0.2%
k	358	0.1%
u	18	< 0.1%
p	18	< 0.1%
Other values (3)	54	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	81878	99.1%
C	358	0.4%
S	358	0.4%
D	18	< 0.1%
O	18	< 0.1%

Space Separator

Value	Count	Frequency (%)
	376	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	332060	99.9%
Common	376	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	82952	25.0%
n	82236	24.8%
e	81914	24.7%
N	81878	24.7%
t	734	0.2%
r	394	0.1%
l	376	0.1%
c	376	0.1%
C	358	0.1%
k	358	0.1%
Other values (8)	484	0.1%

Common

Value	Count	Frequency (%)
	376	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	332436	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	82952	25.0%
n	82236	24.7%
e	81914	24.6%
N	81878	24.6%
t	734	0.2%
r	394	0.1%
l	376	0.1%
c	376	0.1%
	376	0.1%
C	358	0.1%
Other values (9)	842	0.3%

oh_CreatedDate
Date

Distinct	22297
Distinct (%)	27.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

Minimum	2022-10-12 11:22:12
Maximum	2023-11-23 17:15:01

Histogram

Histogram with fixed size bins (bins=50)

oh_DespatchDate
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	82255
Missing (%)	100.0%
Memory size	642.7 KiB

oh_CancelledDate
Date

MISSING

Distinct	12
Distinct (%)	30.8%
Missing	82216
Missing (%)	> 99.9%
Memory size	642.7 KiB

Minimum	2023-11-21 17:11:06.440000
Maximum	2023-11-23 15:55:19.517000

Histogram

Histogram with fixed size bins (bins=12)

oh_Priority
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	8191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16382	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

oh_UserID
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

1000.0	8191

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	49146
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1000.0
2nd row	1000.0
3rd row	1000.0
4th row	1000.0
5th row	1000.0

Common Values

Value	Count	Frequency (%)
1000.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1000.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	32764	66.7%
1	8191	16.7%
.	8191	16.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40955	83.3%
Other Punctuation	8191	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	32764	80.0%
1	8191	20.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	49146	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	32764	66.7%
1	8191	16.7%
.	8191	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49146	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	32764	66.7%
1	8191	16.7%
.	8191	16.7%

oh_CurrencyCode
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	3734
Missing (%)	4.5%
Memory size	642.7 KiB

GBP	78521

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	235563
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GBP
2nd row	GBP
3rd row	GBP
4th row	GBP
5th row	GBP

Common Values

Value	Count	Frequency (%)
GBP	78521	95.5%
(Missing)	3734	4.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gbp	78521	100.0%

Most occurring characters

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	235563	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	235563	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	235563	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

oh_CurrencyRate
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

1.0	8191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	8191	33.3%
.	8191	33.3%
0	8191	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	8191	50.0%
0	8191	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	8191	33.3%
.	8191	33.3%
0	8191	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	8191	33.3%
.	8191	33.3%
0	8191	33.3%

oh_LastActionCode
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	7
Distinct (%)	0.2%
Missing	79234
Missing (%)	96.3%
Memory size	642.7 KiB

CIR	2786
COA	85
RFI	67
CANI	46
CICR	14
Other values (2)	23

Length

Max length	4
Median length	3
Mean length	3.01953
Min length	2

Characters and Unicode

Total characters	9122
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CIR
2nd row	CIR
3rd row	CIR
4th row	CIR
5th row	CIR

Common Values

Value	Count	Frequency (%)
CIR	2786	3.4%
COA	85	0.1%
RFI	67	0.1%
CANI	46	0.1%
CICR	14	< 0.1%
CI	12	< 0.1%
COCR	11	< 0.1%
(Missing)	79234	96.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cir	2786	92.2%
coa	85	2.8%
rfi	67	2.2%
cani	46	1.5%
cicr	14	0.5%
ci	12	0.4%
cocr	11	0.4%

Most occurring characters

Value	Count	Frequency (%)
C	2979	32.7%
I	2925	32.1%
R	2878	31.6%
A	131	1.4%
O	96	1.1%
F	67	0.7%
N	46	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9122	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	2979	32.7%
I	2925	32.1%
R	2878	31.6%
A	131	1.4%
O	96	1.1%
F	67	0.7%
N	46	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9122	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	2979	32.7%
I	2925	32.1%
R	2878	31.6%
A	131	1.4%
O	96	1.1%
F	67	0.7%
N	46	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9122	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	2979	32.7%
I	2925	32.1%
R	2878	31.6%
A	131	1.4%
O	96	1.1%
F	67	0.7%
N	46	0.5%

oh_DueDate
Date

MISSING

Distinct	20046
Distinct (%)	25.6%
Missing	3969
Missing (%)	4.8%
Memory size	642.7 KiB

Minimum	2022-10-12 11:22:12
Maximum	2023-11-23 17:15:01

Histogram

Histogram with fixed size bins (bins=50)

oh_DeliverByDate
Date

MISSING

Distinct	20046
Distinct (%)	25.6%
Missing	3969
Missing (%)	4.8%
Memory size	642.7 KiB

Minimum	2022-10-12 11:22:12
Maximum	2023-11-23 17:15:01

Histogram

Histogram with fixed size bins (bins=50)

oh_ShippingCode
Categorical

HIGH CORRELATION IMBALANCE

Distinct	12
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	642.7 KiB

RMT	49311
CCHERMSTD	17949
CLCC	7538
CCJLP	3726
CCDPDND	1902
Other values (7)	1824

Length

Max length	9
Median length	3
Mean length	4.6685957
Min length	3

Characters and Unicode

Total characters	383992
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RMT
2nd row	RMT
3rd row	RMT
4th row	RMT
5th row	CCDPDND

Common Values

Value	Count	Frequency (%)
RMT	49311	59.9%
CCHERMSTD	17949	21.8%
CLCC	7538	9.2%
CCJLP	3726	4.5%
CCDPDND	1902	2.3%
CCHERMPS	1092	1.3%
GSTD	213	0.3%
CCVRY	163	0.2%
RMGIFT	106	0.1%
GEXP	95	0.1%
Other values (2)	155	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rmt	49311	60.0%
cchermstd	17949	21.8%
clcc	7538	9.2%
ccjlp	3726	4.5%
ccdpdnd	1902	2.3%
cchermps	1092	1.3%
gstd	213	0.3%
ccvry	163	0.2%
rmgift	106	0.1%
gexp	95	0.1%
Other values (2)	155	0.2%

Most occurring characters

Value	Count	Frequency (%)
C	72430	18.9%
R	68700	17.9%
M	68537	17.8%
T	67734	17.6%
D	23868	6.2%
S	19254	5.0%
E	19212	5.0%
H	19041	5.0%
L	11264	2.9%
P	6967	1.8%
Other values (10)	6985	1.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	383834	> 99.9%
Decimal Number	158	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	72430	18.9%
R	68700	17.9%
M	68537	17.9%
T	67734	17.6%
D	23868	6.2%
S	19254	5.0%
E	19212	5.0%
H	19041	5.0%
L	11264	2.9%
P	6967	1.8%
Other values (8)	6827	1.8%

Decimal Number

Value	Count	Frequency (%)
2	79	50.0%
4	79	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	383834	> 99.9%
Common	158	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	72430	18.9%
R	68700	17.9%
M	68537	17.9%
T	67734	17.6%
D	23868	6.2%
S	19254	5.0%
E	19212	5.0%
H	19041	5.0%
L	11264	2.9%
P	6967	1.8%
Other values (8)	6827	1.8%

Common

Value	Count	Frequency (%)
2	79	50.0%
4	79	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	383992	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	72430	18.9%
R	68700	17.9%
M	68537	17.8%
T	67734	17.6%
D	23868	6.2%
S	19254	5.0%
E	19212	5.0%
H	19041	5.0%
L	11264	2.9%
P	6967	1.8%
Other values (10)	6985	1.8%

oh_ShippingReasonCode
Text

CONSTANT MISSING

Distinct	1
Distinct (%)	100.0%
Missing	82254
Missing (%)	> 99.9%
Memory size	642.7 KiB

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	4
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	LD L

Value	Count	Frequency (%)
ld	1	50.0%
l	1	50.0%

Most occurring characters

Value	Count	Frequency (%)
L	2	50.0%
D	1	25.0%
	1	25.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3	75.0%
Space Separator	1	25.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	2	66.7%
D	1	33.3%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3	75.0%
Common	1	25.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	2	66.7%
D	1	33.3%

Common

Value	Count	Frequency (%)
	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	2	50.0%
D	1	25.0%
	1	25.0%

oh_PII
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

****	82254

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	329016
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	****
2nd row	****
3rd row	****
4th row	****
5th row	****

Common Values

Value	Count	Frequency (%)
****	82254	> 99.9%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	82254	100.0%

Most occurring characters

Value	Count	Frequency (%)
*	329016	100.0%

Most occurring categories

Value	Count	Frequency (%)
Other Punctuation	329016	100.0%

Most frequent character per category

Other Punctuation

Value	Count	Frequency (%)
*	329016	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	329016	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
*	329016	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	329016	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
*	329016	100.0%

ol_ClientCode
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

CRW	82254

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	246762
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CRW
2nd row	CRW
3rd row	CRW
4th row	CRW
5th row	CRW

Common Values

Value	Count	Frequency (%)
CRW	82254	> 99.9%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
crw	82254	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	246762	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	246762	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	246762	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	82254	33.3%
R	82254	33.3%
W	82254	33.3%

ol_OrderID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2113
Distinct (%)	25.8%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	6519444.4

Minimum	5421459
Maximum	6555985
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	5421459
5-th percentile	6471496
Q1	6512281.5
median	6525779
Q3	6537162
95-th percentile	6550271.5
Maximum	6555985
Range	1134526
Interquartile range (IQR)	24880.5

Descriptive statistics

Standard deviation	41613.862
Coefficient of variation (CV)	0.0063830381
Kurtosis	191.72675
Mean	6519444.4
Median Absolute Deviation (MAD)	12142
Skewness	-10.705328
Sum	5.3400769 × 10¹⁰
Variance	1.7317135 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6514411	25	< 0.1%
6489908	19	< 0.1%
6552899	18	< 0.1%
6541399	17	< 0.1%
6474533	16	< 0.1%
6533665	15	< 0.1%
6522805	15	< 0.1%
6533159	14	< 0.1%
6482742	14	< 0.1%
6542958	14	< 0.1%
Other values (2103)	8024	9.8%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5421459	2	< 0.1%
5864333	2	< 0.1%
5942595	4	< 0.1%
5983878	7	< 0.1%
6048975	4	< 0.1%
6081160	4	< 0.1%
6111623	4	< 0.1%
6334792	2	< 0.1%
6344916	4	< 0.1%
6345788	3	< 0.1%

Value	Count	Frequency (%)
6555985	1	< 0.1%
6555965	9	< 0.1%
6555919	2	< 0.1%
6555892	9	< 0.1%
6555809	2	< 0.1%
6555777	3	< 0.1%
6555770	3	< 0.1%
6555726	2	< 0.1%
6555724	2	< 0.1%
6555650	6	< 0.1%

ol_ExternalOrderID
Text

Distinct	23772
Distinct (%)	29.0%
Missing	339
Missing (%)	0.4%
Memory size	642.7 KiB

Length

Max length	16
Median length	8
Mean length	8.1055471
Min length	5

Characters and Unicode

Total characters	663974
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2494 ?
Unique (%)	3.0%

Sample

1st row	12841488
2nd row	12841488
3rd row	13158853
4th row	13158853
5th row	13217192

Value	Count	Frequency (%)
13715808	32	< 0.1%
13660449	25	< 0.1%
13719960	24	< 0.1%
13710909	23	< 0.1%
13707110	23	< 0.1%
13666197	21	< 0.1%
13714759	20	< 0.1%
13719757	20	< 0.1%
13708042	20	< 0.1%
13704457	20	< 0.1%
Other values (23762)	81688	99.7%

Most occurring characters

Value	Count	Frequency (%)
1	147525	22.2%
3	119543	18.0%
7	103507	15.6%
0	69125	10.4%
6	44337	6.7%
2	36135	5.4%
8	35524	5.4%
9	35514	5.3%
4	33863	5.1%
5	33859	5.1%
Other values (9)	5042	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	658932	99.2%
Uppercase Letter	4716	0.7%
Dash Punctuation	326	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	147525	22.4%
3	119543	18.1%
7	103507	15.7%
0	69125	10.5%
6	44337	6.7%
2	36135	5.5%
8	35524	5.4%
9	35514	5.4%
4	33863	5.1%
5	33859	5.1%

Uppercase Letter

Value	Count	Frequency (%)
Y	3889	82.5%
V	163	3.5%
E	163	3.5%
R	163	3.5%
O	163	3.5%
S	114	2.4%
M	49	1.0%
X	12	0.3%

Dash Punctuation

Value	Count	Frequency (%)
-	326	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	659258	99.3%
Latin	4716	0.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	147525	22.4%
3	119543	18.1%
7	103507	15.7%
0	69125	10.5%
6	44337	6.7%
2	36135	5.5%
8	35524	5.4%
9	35514	5.4%
4	33863	5.1%
5	33859	5.1%

Latin

Value	Count	Frequency (%)
Y	3889	82.5%
V	163	3.5%
E	163	3.5%
R	163	3.5%
O	163	3.5%
S	114	2.4%
M	49	1.0%
X	12	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	663974	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	147525	22.2%
3	119543	18.0%
7	103507	15.6%
0	69125	10.4%
6	44337	6.7%
2	36135	5.4%
8	35524	5.4%
9	35514	5.3%
4	33863	5.1%
5	33859	5.1%
Other values (9)	5042	0.8%

ol_CustomerID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2037
Distinct (%)	24.9%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	24851252

Minimum	10512
Maximum	34101675
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	10512
5-th percentile	9959870
Q1	17903003
median	25847047
Q3	33849878
95-th percentile	34033050
Maximum	34101675
Range	34091163
Interquartile range (IQR)	15946875

Descriptive statistics

Standard deviation	8493903.9
Coefficient of variation (CV)	0.34178978
Kurtosis	-0.9286762
Mean	24851252
Median Absolute Deviation (MAD)	7998564
Skewness	-0.46525263
Sum	2.035566 × 10¹¹
Variance	7.2146403 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16635245	26	< 0.1%
10425049	25	< 0.1%
15614761	24	< 0.1%
33836149	19	< 0.1%
34087130	18	< 0.1%
17181934	17	< 0.1%
33912221	17	< 0.1%
17162728	16	< 0.1%
33779356	16	< 0.1%
34009472	15	< 0.1%
Other values (2027)	7998	9.7%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10512	7	< 0.1%
494757	3	< 0.1%
691469	3	< 0.1%
989806	3	< 0.1%
1848530	3	< 0.1%
3014983	4	< 0.1%
3396223	3	< 0.1%
3767001	3	< 0.1%
3799000	6	< 0.1%
3809340	7	< 0.1%

Value	Count	Frequency (%)
34101675	1	< 0.1%
34101451	2	< 0.1%
34100990	2	< 0.1%
34100123	6	< 0.1%
34100040	4	< 0.1%
34099788	2	< 0.1%
34099705	2	< 0.1%
34097493	3	< 0.1%
34096024	3	< 0.1%
34095323	4	< 0.1%

ol_LineID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	25
Distinct (%)	0.3%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8921988

Minimum	0
Maximum	24
Zeros	195
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	7
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.3099247
Coefficient of variation (CV)	0.79867427
Kurtosis	11.171599
Mean	2.8921988
Median Absolute Deviation (MAD)	1
Skewness	2.5732805
Sum	23690
Variance	5.3357523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1	2113	2.6%
2	2096	2.5%
3	1609	2.0%
4	896	1.1%
5	497	0.6%
6	267	0.3%
0	195	0.2%
7	166	0.2%
8	103	0.1%
9	69	0.1%
Other values (15)	180	0.2%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	195	0.2%
1	2113	2.6%
2	2096	2.5%
3	1609	2.0%
4	896	1.1%
5	497	0.6%
6	267	0.3%
7	166	0.2%
8	103	0.1%
9	69	0.1%

Value	Count	Frequency (%)
24	2	< 0.1%
23	1	< 0.1%
22	2	< 0.1%
21	1	< 0.1%
20	3	< 0.1%
19	2	< 0.1%
18	5	< 0.1%
17	4	< 0.1%
16	7	< 0.1%
15	8	< 0.1%

ol_CreatedDate
Date

Distinct	82026
Distinct (%)	99.7%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

Minimum	2022-10-12 11:33:22.093000
Maximum	2023-11-23 17:23:24.667000

Histogram

Histogram with fixed size bins (bins=50)

ol_CampaignCode
Categorical

HIGH CORRELATION IMBALANCE

Distinct	11
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

WEBT	76301
JLP	3726
WEBC	1084
UKMO	355
GLBE	308
Other values (6)	480

Length

Max length	4
Median length	4
Mean length	3.9545919
Min length	2

Characters and Unicode

Total characters	325281
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	WEBT
2nd row	WEBT
3rd row	WEBT
4th row	WEBT
5th row	WEBT

Common Values

Value	Count	Frequency (%)
WEBT	76301	92.8%
JLP	3726	4.5%
WEBC	1084	1.3%
UKMO	355	0.4%
GLBE	308	0.4%
GIFT	234	0.3%
VERY	163	0.2%
NXPP	76	0.1%
CAT	4	< 0.1%
MO	2	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
webt	76301	92.8%
jlp	3726	4.5%
webc	1084	1.3%
ukmo	355	0.4%
glbe	308	0.4%
gift	234	0.3%
very	163	0.2%
nxpp	76	0.1%
cat	4	< 0.1%
mo	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	325281	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	325281	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	325281	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	77856	23.9%
B	77693	23.9%
W	77385	23.8%
T	76539	23.5%
L	4034	1.2%
P	3878	1.2%
J	3726	1.1%
C	1088	0.3%
G	542	0.2%
O	358	0.1%
Other values (11)	2182	0.7%

ol_SourceCode
Categorical

HIGH CORRELATION IMBALANCE

Distinct	10
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

WEB	64871
CLIC	7538
AW	5851
JLP	3726
VERY	163
Other values (5)	105

Length

Max length	10
Median length	3
Mean length	3.0245702
Min length	2

Characters and Unicode

Total characters	248783
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WEB
2nd row	WEB
3rd row	WEB
4th row	WEB
5th row	WEB

Common Values

Value	Count	Frequency (%)
WEB	64871	78.9%
CLIC	7538	9.2%
AW	5851	7.1%
JLP	3726	4.5%
VERY	163	0.2%
NXPP	76	0.1%
AWSRC=AW	13	< 0.1%
AT01	9	< 0.1%
CAT	4	< 0.1%
MAIL ORDER	3	< 0.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
web	64871	78.9%
clic	7538	9.2%
aw	5851	7.1%
jlp	3726	4.5%
very	163	0.2%
nxpp	76	0.1%
awsrc=aw	13	< 0.1%
at01	9	< 0.1%
cat	4	< 0.1%
mail	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (13)	547	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	248749	> 99.9%
Decimal Number	18	< 0.1%
Math Symbol	13	< 0.1%
Space Separator	3	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (9)	513	0.2%

Decimal Number

Value	Count	Frequency (%)
0	9	50.0%
1	9	50.0%

Math Symbol

Value	Count	Frequency (%)
=	13	100.0%

Space Separator

Value	Count	Frequency (%)
	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	248749	> 99.9%
Common	34	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (9)	513	0.2%

Common

Value	Count	Frequency (%)
=	13	38.2%
0	9	26.5%
1	9	26.5%
	3	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	248783	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	70748	28.4%
E	65037	26.1%
B	64871	26.1%
C	15093	6.1%
L	11267	4.5%
I	7541	3.0%
A	5893	2.4%
P	3878	1.6%
J	3726	1.5%
R	182	0.1%
Other values (13)	547	0.2%

ol_MediaID
Text

MISSING

Distinct	2
Distinct (%)	66.7%
Missing	82252
Missing (%)	> 99.9%
Memory size	642.7 KiB

Length

Max length	20
Median length	11
Mean length	14
Min length	11

Characters and Unicode

Total characters	42
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	33.3%

Sample

1st row	PHONE Order
2nd row	PHONE Order
3rd row	Verifone PHONE Order

Value	Count	Frequency (%)
phone	3	42.9%
order	3	42.9%
verifone	1	14.3%

Most occurring characters

Value	Count	Frequency (%)
r	7	16.7%
O	6	14.3%
e	5	11.9%
	4	9.5%
P	3	7.1%
H	3	7.1%
N	3	7.1%
E	3	7.1%
d	3	7.1%
V	1	2.4%
Other values (4)	4	9.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19	45.2%
Uppercase Letter	19	45.2%
Space Separator	4	9.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	7	36.8%
e	5	26.3%
d	3	15.8%
i	1	5.3%
f	1	5.3%
o	1	5.3%
n	1	5.3%

Uppercase Letter

Value	Count	Frequency (%)
O	6	31.6%
P	3	15.8%
H	3	15.8%
N	3	15.8%
E	3	15.8%
V	1	5.3%

Space Separator

Value	Count	Frequency (%)
	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	38	90.5%
Common	4	9.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	7	18.4%
O	6	15.8%
e	5	13.2%
P	3	7.9%
H	3	7.9%
N	3	7.9%
E	3	7.9%
d	3	7.9%
V	1	2.6%
i	1	2.6%
Other values (3)	3	7.9%

Common

Value	Count	Frequency (%)
	4	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	7	16.7%
O	6	14.3%
e	5	11.9%
	4	9.5%
P	3	7.1%
H	3	7.1%
N	3	7.1%
E	3	7.1%
d	3	7.1%
V	1	2.4%
Other values (4)	4	9.5%

olProductID
Text

Distinct	8013
Distinct (%)	9.7%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

Length

Max length	15
Median length	7
Mean length	7.2566684
Min length	5

Characters and Unicode

Total characters	596890
Distinct characters	31
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2913 ?
Unique (%)	3.5%

Sample

1st row	1221290
2nd row	FRL-999
3rd row	1250824
4th row	FRL-999
5th row	1246696

Value	Count	Frequency (%)
frl-999	20660	25.1%
intro	5384	6.5%
system_shipping	3959	4.8%
1223300	479	0.6%
1278237	369	0.4%
1179890	305	0.4%
1167786	277	0.3%
1278240	268	0.3%
1278238	262	0.3%
1269082	254	0.3%
Other values (8003)	50037	60.8%

Most occurring characters

Value	Count	Frequency (%)
9	81299	13.6%
1	77412	13.0%
2	67709	11.3%
7	45672	7.7%
8	34552	5.8%
3	27405	4.6%
R	26107	4.4%
6	25192	4.2%
4	23546	3.9%
5	23028	3.9%
Other values (21)	164968	27.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	427417	71.6%
Uppercase Letter	144850	24.3%
Dash Punctuation	20660	3.5%
Connector Punctuation	3963	0.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	26107	18.0%
F	20719	14.3%
L	20664	14.3%
I	13361	9.2%
S	11877	8.2%
T	9406	6.5%
N	9343	6.5%
P	7918	5.5%
O	5388	3.7%
G	4022	2.8%
Other values (9)	16045	11.1%

Decimal Number

Value	Count	Frequency (%)
9	81299	19.0%
1	77412	18.1%
2	67709	15.8%
7	45672	10.7%
8	34552	8.1%
3	27405	6.4%
6	25192	5.9%
4	23546	5.5%
5	23028	5.4%
0	21602	5.1%

Dash Punctuation

Value	Count	Frequency (%)
-	20660	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3963	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	452040	75.7%
Latin	144850	24.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	26107	18.0%
F	20719	14.3%
L	20664	14.3%
I	13361	9.2%
S	11877	8.2%
T	9406	6.5%
N	9343	6.5%
P	7918	5.5%
O	5388	3.7%
G	4022	2.8%
Other values (9)	16045	11.1%

Common

Value	Count	Frequency (%)
9	81299	18.0%
1	77412	17.1%
2	67709	15.0%
7	45672	10.1%
8	34552	7.6%
3	27405	6.1%
6	25192	5.6%
4	23546	5.2%
5	23028	5.1%
0	21602	4.8%
Other values (2)	24623	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	596890	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	81299	13.6%
1	77412	13.0%
2	67709	11.3%
7	45672	7.7%
8	34552	5.8%
3	27405	4.6%
R	26107	4.4%
6	25192	4.2%
4	23546	3.9%
5	23028	3.9%
Other values (21)	164968	27.6%

ol_Quantity
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	5
Distinct (%)	0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

1.0	8136
2.0	48
3.0	4
4.0	2
5.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	8136	9.9%
2.0	48	0.1%
3.0	4	< 0.1%
4.0	2	< 0.1%
5.0	1	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	8136	99.3%
2.0	48	0.6%
3.0	4	< 0.1%
4.0	2	< 0.1%
5.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
1	8136	33.1%
2	48	0.2%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	8191	50.0%
1	8136	49.7%
2	48	0.3%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
1	8136	33.1%
2	48	0.2%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
1	8136	33.1%
2	48	0.2%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

ol_QuantityDespatched
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6
Distinct (%)	0.1%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0050055

Minimum	0
Maximum	5
Zeros	25
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.12244696
Coefficient of variation (CV)	0.1218371
Kurtosis	296.79837
Mean	1.0050055
Median Absolute Deviation (MAD)	0
Skewness	11.385912
Sum	8232
Variance	0.014993257
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	8111	9.9%
2	48	0.1%
0	25	< 0.1%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25	< 0.1%
1	8111	9.9%
2	48	0.1%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
5	1	< 0.1%
4	2	< 0.1%
3	4	< 0.1%
2	48	0.1%
1	8111	9.9%
0	25	< 0.1%

ol_DespatchedDate
Date

MISSING

Distinct	66189
Distinct (%)	99.8%
Missing	15965
Missing (%)	19.4%
Memory size	642.7 KiB

Minimum	2022-10-13 11:29:20.203000
Maximum	2023-11-23 16:53:23.680000

Histogram

Histogram with fixed size bins (bins=50)

ol_LineMajorStatus
Categorical

HIGH CORRELATION IMBALANCE

Distinct	12
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

Despatch Confirmed	62347
Torque Processing	9571
Ready For Despatch	5329
Cancelled	3852
Ship from Store Processing	563
Other values (7)	592

Length

Max length	26
Median length	18
Mean length	17.472451
Min length	7

Characters and Unicode

Total characters	1437179
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cancelled
2nd row	Despatch Confirmed
3rd row	Cancelled
4th row	Despatch Confirmed
5th row	Cancelled

Common Values

Value	Count	Frequency (%)
Despatch Confirmed	62347	75.8%
Torque Processing	9571	11.6%
Ready For Despatch	5329	6.5%
Cancelled	3852	4.7%
Ship from Store Processing	563	0.7%
Replaced	216	0.3%
Picking at Store	165	0.2%
Stock Control	95	0.1%
Torque Queued	70	0.1%
Swapped	23	< 0.1%
Other values (2)	23	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
despatch	67676	40.5%
confirmed	62347	37.3%
processing	10134	6.1%
torque	9641	5.8%
for	5334	3.2%
ready	5329	3.2%
cancelled	3852	2.3%
store	728	0.4%
ship	563	0.3%
from	563	0.3%
Other values (11)	875	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	164190	11.4%
o	89073	6.2%
r	88860	6.2%
s	87980	6.1%
	84788	5.9%
c	82161	5.7%
a	77266	5.4%
n	76603	5.3%
i	73389	5.1%
d	71855	5.0%
Other values (23)	541014	37.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1186077	82.5%
Uppercase Letter	166314	11.6%
Space Separator	84788	5.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	164190	13.8%
o	89073	7.5%
r	88860	7.5%
s	87980	7.4%
c	82161	6.9%
a	77266	6.5%
n	76603	6.5%
i	73389	6.2%
d	71855	6.1%
t	68787	5.8%
Other values (11)	305913	25.8%

Uppercase Letter

Value	Count	Frequency (%)
D	67676	40.7%
C	66294	39.9%
P	10317	6.2%
T	9641	5.8%
R	5545	3.3%
F	5334	3.2%
S	1409	0.8%
Q	70	< 0.1%
N	18	< 0.1%
W	5	< 0.1%

Space Separator

Value	Count	Frequency (%)
	84788	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1352391	94.1%
Common	84788	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	164190	12.1%
o	89073	6.6%
r	88860	6.6%
s	87980	6.5%
c	82161	6.1%
a	77266	5.7%
n	76603	5.7%
i	73389	5.4%
d	71855	5.3%
t	68787	5.1%
Other values (22)	472227	34.9%

Common

Value	Count	Frequency (%)
	84788	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1437179	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	164190	11.4%
o	89073	6.2%
r	88860	6.2%
s	87980	6.1%
	84788	5.9%
c	82161	5.7%
a	77266	5.4%
n	76603	5.3%
i	73389	5.1%
d	71855	5.0%
Other values (23)	541014	37.6%

ol_LineMinorStatus
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	26934
Missing (%)	32.7%
Memory size	642.7 KiB

Charge Confirmed	37377
Allocated	5653
Waiting For Other Tender	4613
Refund Confirmed	3678
Picked	1890
Other values (7)	2110

Length

Max length	24
Median length	16
Mean length	15.258762
Min length	6

Characters and Unicode

Total characters	844130
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Refund Confirmed
2nd row	Refund Confirmed
3rd row	Failed Payment Process
4th row	Charge Confirmed
5th row	Refund Confirmed

Common Values

Value	Count	Frequency (%)
Charge Confirmed	37377	45.4%
Allocated	5653	6.9%
Waiting For Other Tender	4613	5.6%
Refund Confirmed	3678	4.5%
Picked	1890	2.3%
Packed	1527	1.9%
Complete	447	0.5%
Item TOS	55	0.1%
In Progress	40	< 0.1%
Waiting For TOS Item	23	< 0.1%
Other values (2)	18	< 0.1%
(Missing)	26934	32.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
confirmed	41055	37.2%
charge	37377	33.9%
allocated	5653	5.1%
waiting	4636	4.2%
for	4636	4.2%
other	4613	4.2%
tender	4613	4.2%
refund	3678	3.3%
picked	1890	1.7%
packed	1527	1.4%
Other values (9)	737	0.7%

Most occurring characters

Value	Count	Frequency (%)
e	106068	12.6%
r	92375	10.9%
C	78879	9.3%
d	58434	6.9%
	55094	6.5%
n	54023	6.4%
i	52218	6.2%
o	51832	6.1%
a	49195	5.8%
f	44733	5.3%
Other values (21)	201279	23.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	678431	80.4%
Uppercase Letter	110605	13.1%
Space Separator	55094	6.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	106068	15.6%
r	92375	13.6%
d	58434	8.6%
n	54023	8.0%
i	52218	7.7%
o	51832	7.6%
a	49195	7.3%
f	44733	6.6%
g	42053	6.2%
h	41990	6.2%
Other values (9)	85510	12.6%

Uppercase Letter

Value	Count	Frequency (%)
C	78879	71.3%
A	5653	5.1%
O	4708	4.3%
T	4708	4.3%
F	4637	4.2%
W	4636	4.2%
R	3678	3.3%
P	3459	3.1%
I	135	0.1%
S	95	0.1%

Space Separator

Value	Count	Frequency (%)
	55094	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	789036	93.5%
Common	55094	6.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	106068	13.4%
r	92375	11.7%
C	78879	10.0%
d	58434	7.4%
n	54023	6.8%
i	52218	6.6%
o	51832	6.6%
a	49195	6.2%
f	44733	5.7%
g	42053	5.3%
Other values (20)	159226	20.2%

Common

Value	Count	Frequency (%)
	55094	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	844130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	106068	12.6%
r	92375	10.9%
C	78879	9.3%
d	58434	6.9%
	55094	6.5%
n	54023	6.4%
i	52218	6.2%
o	51832	6.1%
a	49195	5.8%
f	44733	5.3%
Other values (21)	201279	23.8%

ol_SkuStatus
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

10.0	5418
9999.0	2772
0.0	1

Length

Max length	6
Median length	4
Mean length	4.6767183
Min length	3

Characters and Unicode

Total characters	38307
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	10.0
2nd row	9999.0
3rd row	10.0
4th row	9999.0
5th row	10.0

Common Values

Value	Count	Frequency (%)
10.0	5418	6.6%
9999.0	2772	3.4%
0.0	1	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
10.0	5418	66.1%
9999.0	2772	33.8%
0.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	13610	35.5%
9	11088	28.9%
.	8191	21.4%
1	5418	14.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	30116	78.6%
Other Punctuation	8191	21.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13610	45.2%
9	11088	36.8%
1	5418	18.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	38307	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13610	35.5%
9	11088	28.9%
.	8191	21.4%
1	5418	14.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13610	35.5%
9	11088	28.9%
.	8191	21.4%
1	5418	14.1%

ol_SkuStockStatus
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

10.0	4521
0.0	3662
50.0	8

Length

Max length	4
Median length	4
Mean length	3.5529239
Min length	3

Characters and Unicode

Total characters	29102
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	10.0
3rd row	0.0
4th row	10.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
10.0	4521	5.5%
0.0	3662	4.5%
50.0	8	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
10.0	4521	55.2%
0.0	3662	44.7%
50.0	8	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	16382	56.3%
.	8191	28.1%
1	4521	15.5%
5	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20911	71.9%
Other Punctuation	8191	28.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16382	78.3%
1	4521	21.6%
5	8	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	29102	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16382	56.3%
.	8191	28.1%
1	4521	15.5%
5	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29102	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16382	56.3%
.	8191	28.1%
1	4521	15.5%
5	8	< 0.1%

ol_PaymentMajorStatus
Categorical

HIGH CORRELATION MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	30576
Missing (%)	37.2%
Memory size	642.7 KiB

Charged	37878
Authed	10122
Refunded	3678
FailedRefund	1

Length

Max length	12
Median length	7
Mean length	6.8754039
Min length	6

Characters and Unicode

Total characters	355314
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Refunded
2nd row	Refunded
3rd row	FailedRefund
4th row	Charged
5th row	Charged

Common Values

Value	Count	Frequency (%)
Charged	37878	46.0%
Authed	10122	12.3%
Refunded	3678	4.5%
FailedRefund	1	< 0.1%
(Missing)	30576	37.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
charged	37878	73.3%
authed	10122	19.6%
refunded	3678	7.1%
failedrefund	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	55358	15.6%
d	55358	15.6%
h	48000	13.5%
a	37879	10.7%
C	37878	10.7%
r	37878	10.7%
g	37878	10.7%
u	13801	3.9%
A	10122	2.8%
t	10122	2.8%
Other values (6)	11040	3.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	303634	85.5%
Uppercase Letter	51680	14.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	55358	18.2%
d	55358	18.2%
h	48000	15.8%
a	37879	12.5%
r	37878	12.5%
g	37878	12.5%
u	13801	4.5%
t	10122	3.3%
f	3679	1.2%
n	3679	1.2%
Other values (2)	2	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
C	37878	73.3%
A	10122	19.6%
R	3679	7.1%
F	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	355314	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	55358	15.6%
d	55358	15.6%
h	48000	13.5%
a	37879	10.7%
C	37878	10.7%
r	37878	10.7%
g	37878	10.7%
u	13801	3.9%
A	10122	2.8%
t	10122	2.8%
Other values (6)	11040	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	355314	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	55358	15.6%
d	55358	15.6%
h	48000	13.5%
a	37879	10.7%
C	37878	10.7%
r	37878	10.7%
g	37878	10.7%
u	13801	3.9%
A	10122	2.8%
t	10122	2.8%
Other values (6)	11040	3.1%

ol_PaymentMinorStatus
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	30577
Missing (%)	37.2%
Memory size	642.7 KiB

Complete	51678

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	413424
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Complete
2nd row	Complete
3rd row	Complete
4th row	Complete
5th row	Complete

Common Values

Value	Count	Frequency (%)
Complete	51678	62.8%
(Missing)	30577	37.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
complete	51678	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	103356	25.0%
C	51678	12.5%
o	51678	12.5%
m	51678	12.5%
p	51678	12.5%
l	51678	12.5%
t	51678	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	361746	87.5%
Uppercase Letter	51678	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	103356	28.6%
o	51678	14.3%
m	51678	14.3%
p	51678	14.3%
l	51678	14.3%
t	51678	14.3%

Uppercase Letter

Value	Count	Frequency (%)
C	51678	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	413424	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	103356	25.0%
C	51678	12.5%
o	51678	12.5%
m	51678	12.5%
p	51678	12.5%
l	51678	12.5%
t	51678	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	413424	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	103356	25.0%
C	51678	12.5%
o	51678	12.5%
m	51678	12.5%
p	51678	12.5%
l	51678	12.5%
t	51678	12.5%

ol_PaymentMethod
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

2.0	8107
4.0	45
1.0	39

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	2.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	8107	9.9%
4.0	45	0.1%
1.0	39	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	8107	99.0%
4.0	45	0.5%
1.0	39	0.5%

Most occurring characters

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
2	8107	33.0%
4	45	0.2%
1	39	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	8191	50.0%
2	8107	49.5%
4	45	0.3%
1	39	0.2%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
2	8107	33.0%
4	45	0.2%
1	39	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	8191	33.3%
0	8191	33.3%
2	8107	33.0%
4	45	0.2%
1	39	0.2%

ol_PaymentType
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	82255
Missing (%)	100.0%
Memory size	642.7 KiB

ol_CancelledDate
Date

MISSING

Distinct	4119
Distinct (%)	100.0%
Missing	78136
Missing (%)	95.0%
Memory size	642.7 KiB

Minimum	2023-05-11 11:42:07.973000
Maximum	2023-11-23 17:25:08.793000

Histogram

Histogram with fixed size bins (bins=50)

ol_LastActionCode
Categorical

HIGH CORRELATION MISSING

Distinct	11
Distinct (%)	0.4%
Missing	79709
Missing (%)	96.9%
Memory size	642.7 KiB

SAR	1138
CIR	985
RI	240
CI	83
RFI	46
Other values (6)	54

Length

Max length	4
Median length	3
Mean length	2.8762765
Min length	2

Characters and Unicode

Total characters	7323
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	RFI
2nd row	SAR
3rd row	RFI
4th row	SI
5th row	SI

Common Values

Value	Count	Frequency (%)
SAR	1138	1.4%
CIR	985	1.2%
RI	240	0.3%
CI	83	0.1%
RFI	46	0.1%
SI	22	< 0.1%
CANI	17	< 0.1%
CICR	7	< 0.1%
EXUN	6	< 0.1%
SIR	1	< 0.1%
(Missing)	79709	96.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sar	1138	44.7%
cir	985	38.7%
ri	240	9.4%
ci	83	3.3%
rfi	46	1.8%
si	22	0.9%
cani	17	0.7%
cicr	7	0.3%
exun	6	0.2%
sir	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
R	2417	33.0%
I	1402	19.1%
S	1161	15.9%
A	1155	15.8%
C	1100	15.0%
F	46	0.6%
N	23	0.3%
E	6	0.1%
X	6	0.1%
U	6	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7323	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	2417	33.0%
I	1402	19.1%
S	1161	15.9%
A	1155	15.8%
C	1100	15.0%
F	46	0.6%
N	23	0.3%
E	6	0.1%
X	6	0.1%
U	6	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7323	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	2417	33.0%
I	1402	19.1%
S	1161	15.9%
A	1155	15.8%
C	1100	15.0%
F	46	0.6%
N	23	0.3%
E	6	0.1%
X	6	0.1%
U	6	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7323	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	2417	33.0%
I	1402	19.1%
S	1161	15.9%
A	1155	15.8%
C	1100	15.0%
F	46	0.6%
N	23	0.3%
E	6	0.1%
X	6	0.1%
U	6	0.1%

ol_ParentItemNumber
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	8191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16382	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

ol_Priority
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	8191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16382	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16382	66.7%
.	8191	33.3%

ol_UserID
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

1000.0	8191

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	49146
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1000.0
2nd row	1000.0
3rd row	1000.0
4th row	1000.0
5th row	1000.0

Common Values

Value	Count	Frequency (%)
1000.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1000.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	32764	66.7%
1	8191	16.7%
.	8191	16.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40955	83.3%
Other Punctuation	8191	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	32764	80.0%
1	8191	20.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	49146	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	32764	66.7%
1	8191	16.7%
.	8191	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49146	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	32764	66.7%
1	8191	16.7%
.	8191	16.7%

ol_CurrencyCode
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	3734
Missing (%)	4.5%
Memory size	642.7 KiB

GBP	78521

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	235563
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GBP
2nd row	GBP
3rd row	GBP
4th row	GBP
5th row	GBP

Common Values

Value	Count	Frequency (%)
GBP	78521	95.5%
(Missing)	3734	4.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gbp	78521	100.0%

Most occurring characters

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	235563	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	235563	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	235563	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	78521	33.3%
B	78521	33.3%
P	78521	33.3%

ol_CurrencyRate
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

1.0	8191

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	24573
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	8191	10.0%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	8191	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	8191	33.3%
.	8191	33.3%
0	8191	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16382	66.7%
Other Punctuation	8191	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	8191	50.0%
0	8191	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24573	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	8191	33.3%
.	8191	33.3%
0	8191	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	8191	33.3%
.	8191	33.3%
0	8191	33.3%

ol_ShippingCode
Categorical

HIGH CORRELATION MISSING

Distinct	4
Distinct (%)	1.5%
Missing	81996
Missing (%)	99.7%
Memory size	642.7 KiB

CCDPDND	134
RMT24	64
GC	59
RMGIFT	2

Length

Max length	7
Median length	7
Mean length	5.3590734
Min length	2

Characters and Unicode

Total characters	1388
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RMT24
2nd row	RMT24
3rd row	RMT24
4th row	RMT24
5th row	CCDPDND

Common Values

Value	Count	Frequency (%)
CCDPDND	134	0.2%
RMT24	64	0.1%
GC	59	0.1%
RMGIFT	2	< 0.1%
(Missing)	81996	99.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ccdpdnd	134	51.7%
rmt24	64	24.7%
gc	59	22.8%
rmgift	2	0.8%

Most occurring characters

Value	Count	Frequency (%)
D	402	29.0%
C	327	23.6%
P	134	9.7%
N	134	9.7%
R	66	4.8%
M	66	4.8%
T	66	4.8%
2	64	4.6%
4	64	4.6%
G	61	4.4%
Other values (2)	4	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1260	90.8%
Decimal Number	128	9.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	402	31.9%
C	327	26.0%
P	134	10.6%
N	134	10.6%
R	66	5.2%
M	66	5.2%
T	66	5.2%
G	61	4.8%
I	2	0.2%
F	2	0.2%

Decimal Number

Value	Count	Frequency (%)
2	64	50.0%
4	64	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1260	90.8%
Common	128	9.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	402	31.9%
C	327	26.0%
P	134	10.6%
N	134	10.6%
R	66	5.2%
M	66	5.2%
T	66	5.2%
G	61	4.8%
I	2	0.2%
F	2	0.2%

Common

Value	Count	Frequency (%)
2	64	50.0%
4	64	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1388	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	402	29.0%
C	327	23.6%
P	134	9.7%
N	134	9.7%
R	66	4.8%
M	66	4.8%
T	66	4.8%
2	64	4.6%
4	64	4.6%
G	61	4.4%
Other values (2)	4	0.3%

ol_InvoiceNumber
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2091
Distinct (%)	25.5%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	7573128.2

Minimum	0
Maximum	7772737
Zeros	136
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	7631945
Q1	7690921.5
median	7709227
Q3	7721807
95-th percentile	7737494
Maximum	7772737
Range	7772737
Interquartile range (IQR)	30885.5

Descriptive statistics

Standard deviation	985395.03
Coefficient of variation (CV)	0.13011731
Kurtosis	54.974022
Mean	7573128.2
Median Absolute Deviation (MAD)	15001
Skewness	-7.5380247
Sum	6.2031493 × 10¹⁰
Variance	9.7100336 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	136	0.2%
7694229	25	< 0.1%
7740783	18	< 0.1%
7663653	17	< 0.1%
7727136	16	< 0.1%
7718126	15	< 0.1%
7706764	15	< 0.1%
7691221	14	< 0.1%
7717482	14	< 0.1%
7650480	14	< 0.1%
Other values (2081)	7907	9.6%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	136	0.2%
6360410	2	< 0.1%
6888122	2	< 0.1%
6982897	4	< 0.1%
7037174	4	< 0.1%
7064757	2	< 0.1%
7114282	4	< 0.1%
7152944	4	< 0.1%
7191495	4	< 0.1%
7470866	1	< 0.1%

Value	Count	Frequency (%)
7772737	2	< 0.1%
7769224	2	< 0.1%
7756251	1	< 0.1%
7756250	1	< 0.1%
7743939	1	< 0.1%
7743913	9	< 0.1%
7743866	2	< 0.1%
7743828	9	< 0.1%
7743739	2	< 0.1%
7743699	3	< 0.1%

ol_ItemCostPrice
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	37
Distinct (%)	0.5%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.061087779

Minimum	0
Maximum	39.46
Zeros	8145
Zeros (%)	9.9%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	39.46
Range	39.46
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0075274
Coefficient of variation (CV)	16.493109
Kurtosis	656.11685
Mean	0.061087779
Median Absolute Deviation (MAD)	0
Skewness	23.075982
Sum	500.37
Variance	1.0151115
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	8145	9.9%
3.83	2	< 0.1%
10.31	2	< 0.1%
4.3	2	< 0.1%
5.48	2	< 0.1%
7.17	2	< 0.1%
11.86	2	< 0.1%
9.75	2	< 0.1%
12.94	2	< 0.1%
9.86	2	< 0.1%
Other values (27)	28	< 0.1%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8145	9.9%
2.42	1	< 0.1%
2.45	1	< 0.1%
2.76	1	< 0.1%
3.5	1	< 0.1%
3.65	1	< 0.1%
3.83	2	< 0.1%
3.98	1	< 0.1%
4.3	2	< 0.1%
5.4	1	< 0.1%

Value	Count	Frequency (%)
39.46	1	< 0.1%
33.36	1	< 0.1%
26.61	1	< 0.1%
26.05	1	< 0.1%
25.25	1	< 0.1%
19.97	1	< 0.1%
14.95	1	< 0.1%
14.75	1	< 0.1%
13.44	1	< 0.1%
12.94	2	< 0.1%

ol_ItemUnitPrice
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	221
Distinct (%)	2.7%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.002095

Minimum	0
Maximum	209.25
Zeros	2774
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	29
Q3	48.75
95-th percentile	75
Maximum	209.25
Range	209.25
Interquartile range (IQR)	48.75

Descriptive statistics

Standard deviation	28.913988
Coefficient of variation (CV)	0.96373231
Kurtosis	2.3853143
Mean	30.002095
Median Absolute Deviation (MAD)	23.5
Skewness	1.0951763
Sum	245747.16
Variance	836.01872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2774	3.4%
44.25	580	0.7%
48.75	465	0.6%
51.75	199	0.2%
41.3	177	0.2%
56.25	168	0.2%
45.5	163	0.2%
48.3	147	0.2%
52.5	140	0.2%
18.75	140	0.2%
Other values (211)	3238	3.9%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2774	3.4%
3.6	2	< 0.1%
4	2	< 0.1%
4.5	1	< 0.1%
6	1	< 0.1%
6.3	2	< 0.1%
7	4	< 0.1%
7.2	6	< 0.1%
8	8	< 0.1%
8.1	2	< 0.1%

Value	Count	Frequency (%)
209.25	2	< 0.1%
200	1	< 0.1%
199	2	< 0.1%
189	1	< 0.1%
171.75	2	< 0.1%
169	3	< 0.1%
168.75	11	< 0.1%
159	1	< 0.1%
149.25	5	< 0.1%
149	3	< 0.1%

ol_NetAmount
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	359
Distinct (%)	4.4%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.088846

Minimum	0
Maximum	200
Zeros	2579
Zeros (%)	3.1%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	24.38
Q3	40.63
95-th percentile	61.88
Maximum	200
Range	200
Interquartile range (IQR)	40.63

Descriptive statistics

Standard deviation	23.8357
Coefficient of variation (CV)	0.95005167
Kurtosis	2.8107856
Mean	25.088846
Median Absolute Deviation (MAD)	19.37
Skewness	1.1356838
Sum	205502.74
Variance	568.14061
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2579	3.1%
36.88	566	0.7%
40.63	450	0.5%
43.13	187	0.2%
34.42	174	0.2%
46.88	165	0.2%
37.92	161	0.2%
43.75	143	0.2%
40.25	142	0.2%
3.29	134	0.2%
Other values (349)	3490	4.2%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2579	3.1%
2.92	8	< 0.1%
3.29	134	0.2%
3.33	2	< 0.1%
3.6	2	< 0.1%
4.5	1	< 0.1%
4.96	53	0.1%
6	3	< 0.1%
6.3	2	< 0.1%
6.67	5	< 0.1%

Value	Count	Frequency (%)
200	1	< 0.1%
189	1	< 0.1%
174.38	2	< 0.1%
165.83	1	< 0.1%
143.13	2	< 0.1%
140.83	3	< 0.1%
140.63	8	< 0.1%
139	2	< 0.1%
133.59	3	< 0.1%
132.67	1	< 0.1%

ol_TaxValue
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	283
Distinct (%)	3.5%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.7494518

Minimum	0
Maximum	34.87
Zeros	3037
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4.5
Q3	8.12
95-th percentile	12.37
Maximum	34.87
Range	34.87
Interquartile range (IQR)	8.12

Descriptive statistics

Standard deviation	4.8321633
Coefficient of variation (CV)	1.0174149
Kurtosis	2.054757
Mean	4.7494518
Median Absolute Deviation (MAD)	4.5
Skewness	1.0774021
Sum	38902.76
Variance	23.349802
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3037	3.7%
7.37	563	0.7%
8.12	443	0.5%
8.62	188	0.2%
6.88	173	0.2%
9.37	164	0.2%
7.58	161	0.2%
8.75	143	0.2%
8.05	142	0.2%
0.66	134	0.2%
Other values (273)	3043	3.7%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3037	3.7%
0.58	8	< 0.1%
0.66	134	0.2%
0.67	2	< 0.1%
0.99	53	0.1%
1.2	2	< 0.1%
1.33	5	< 0.1%
1.35	1	< 0.1%
1.42	2	< 0.1%
1.5	14	< 0.1%

Value	Count	Frequency (%)
34.87	2	< 0.1%
33.17	1	< 0.1%
28.62	2	< 0.1%
28.17	3	< 0.1%
28.12	8	< 0.1%
26.72	3	< 0.1%
26.53	1	< 0.1%
26.5	1	< 0.1%
24.87	5	< 0.1%
24.83	2	< 0.1%

ol_GrossValue
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	330
Distinct (%)	4.0%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.838269

Minimum	0
Maximum	209.25
Zeros	2579
Zeros (%)	3.1%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	29
Q3	48.75
95-th percentile	74.25
Maximum	209.25
Range	209.25
Interquartile range (IQR)	48.75

Descriptive statistics

Standard deviation	28.502492
Coefficient of variation (CV)	0.95523277
Kurtosis	2.4825114
Mean	29.838269
Median Absolute Deviation (MAD)	23.05
Skewness	1.1123974
Sum	244405.26
Variance	812.39206
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2579	3.1%
44.25	568	0.7%
48.75	453	0.6%
51.75	189	0.2%
41.3	174	0.2%
56.25	165	0.2%
45.5	161	0.2%
52.5	143	0.2%
48.3	142	0.2%
3.95	134	0.2%
Other values (320)	3483	4.2%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2579	3.1%
3.5	8	< 0.1%
3.6	2	< 0.1%
3.95	134	0.2%
4	2	< 0.1%
4.5	1	< 0.1%
5.95	53	0.1%
6	1	< 0.1%
6.3	2	< 0.1%
7	4	< 0.1%

Value	Count	Frequency (%)
209.25	2	< 0.1%
200	1	< 0.1%
199	1	< 0.1%
189	1	< 0.1%
171.75	2	< 0.1%
169	3	< 0.1%
168.75	8	< 0.1%
160.31	3	< 0.1%
159.2	1	< 0.1%
159	1	< 0.1%

ol_AmountPaid
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	340
Distinct (%)	4.2%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.560443

Minimum	0
Maximum	209.25
Zeros	2631
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	28.8
Q3	48.75
95-th percentile	74.25
Maximum	209.25
Range	209.25
Interquartile range (IQR)	48.75

Descriptive statistics

Standard deviation	28.522222
Coefficient of variation (CV)	0.96487801
Kurtosis	2.495342
Mean	29.560443
Median Absolute Deviation (MAD)	22.95
Skewness	1.1236291
Sum	242129.59
Variance	813.51712
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2631	3.2%
44.25	564	0.7%
48.75	449	0.5%
51.75	188	0.2%
41.3	174	0.2%
56.25	163	0.2%
45.5	161	0.2%
48.3	142	0.2%
52.5	141	0.2%
3.95	132	0.2%
Other values (330)	3446	4.2%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2631	3.2%
3.5	7	< 0.1%
3.6	2	< 0.1%
3.95	132	0.2%
4	2	< 0.1%
4.5	1	< 0.1%
5.95	52	0.1%
6	1	< 0.1%
6.3	2	< 0.1%
7	4	< 0.1%

Value	Count	Frequency (%)
209.25	2	< 0.1%
200	1	< 0.1%
199	1	< 0.1%
189	1	< 0.1%
171.75	2	< 0.1%
169	3	< 0.1%
168.75	8	< 0.1%
160.31	3	< 0.1%
159.2	1	< 0.1%
159	1	< 0.1%

ol_AmountRefunded
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	300
Distinct (%)	8.2%
Missing	78577
Missing (%)	95.5%
Infinite	0
Infinite (%)	0.0%
Mean	48.021743

Minimum	2.25
Maximum	199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	2.25
5-th percentile	17
Q1	34.6025
median	45.5
Q3	55
95-th percentile	96.75
Maximum	199
Range	196.75
Interquartile range (IQR)	20.3975

Descriptive statistics

Standard deviation	23.968513
Coefficient of variation (CV)	0.49911794
Kurtosis	5.3500996
Mean	48.021743
Median Absolute Deviation (MAD)	9.8
Skewness	1.7666134
Sum	176623.97
Variance	574.48963
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44.25	391	0.5%
48.75	318	0.4%
51.75	146	0.2%
41.3	126	0.2%
48.3	124	0.2%
56.25	120	0.1%
45.5	117	0.1%
52.5	94	0.1%
18.75	71	0.1%
30	65	0.1%
Other values (290)	2106	2.6%
(Missing)	78577	95.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.25	1	< 0.1%
3.5	1	< 0.1%
3.6	1	< 0.1%
3.95	6	< 0.1%
5.95	2	< 0.1%
6	1	< 0.1%
6.3	1	< 0.1%
7	3	< 0.1%
7.2	1	< 0.1%
8	4	< 0.1%

Value	Count	Frequency (%)
199	1	< 0.1%
171.75	2	< 0.1%
169	2	< 0.1%
168.75	10	< 0.1%
160.31	3	< 0.1%
159.2	1	< 0.1%
159	1	< 0.1%
157.5	1	< 0.1%
149.25	3	< 0.1%
149	2	< 0.1%

ol_PostageValue
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	82255
Missing (%)	100.0%
Memory size	642.7 KiB

ol_PostageTaxValue
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	82255
Missing (%)	100.0%
Memory size	642.7 KiB

ol_PostageReasonCode
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	82255
Missing (%)	100.0%
Memory size	642.7 KiB

ol_DiscountValue
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	126
Distinct (%)	1.5%
Missing	74064
Missing (%)	90.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50665609

Minimum	0
Maximum	42
Zeros	7796
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	642.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	42
Range	42
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.6119893
Coefficient of variation (CV)	5.1553497
Kurtosis	46.010176
Mean	0.50665609
Median Absolute Deviation (MAD)	0
Skewness	6.2003332
Sum	4150.02
Variance	6.8224881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7796	9.5%
8.86	35	< 0.1%
14	21	< 0.1%
9.74	19	< 0.1%
11.8	15	< 0.1%
17.5	14	< 0.1%
11.86	12	< 0.1%
10.34	11	< 0.1%
8.33	11	< 0.1%
15.8	11	< 0.1%
Other values (116)	246	0.3%
(Missing)	74064	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7796	9.5%
0.46	2	< 0.1%
0.68	1	< 0.1%
0.7	1	< 0.1%
0.94	7	< 0.1%
1.09	1	< 0.1%
1.12	1	< 0.1%
1.25	1	< 0.1%
1.28	1	< 0.1%
1.31	1	< 0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
39.8	1	< 0.1%
27.8	2	< 0.1%
27.5	2	< 0.1%
25.8	1	< 0.1%
24.11	2	< 0.1%
23.33	1	< 0.1%
22.5	1	< 0.1%
22.34	1	< 0.1%
22	2	< 0.1%

ol_DiscountReasonCode
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	0.2%
Missing	81831
Missing (%)	99.5%
Memory size	642.7 KiB

WEB	424

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1272
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WEB
2nd row	WEB
3rd row	WEB
4th row	WEB
5th row	WEB

Common Values

Value	Count	Frequency (%)
WEB	424	0.5%
(Missing)	81831	99.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
web	424	100.0%

Most occurring characters

Value	Count	Frequency (%)
W	424	33.3%
E	424	33.3%
B	424	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1272	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	424	33.3%
E	424	33.3%
B	424	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1272	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	424	33.3%
E	424	33.3%
B	424	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1272	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	424	33.3%
E	424	33.3%
B	424	33.3%

ol_TaxLocale
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	33.3%
Missing	82252
Missing (%)	> 99.9%
Memory size	642.7 KiB

GB	3

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	6
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GB
2nd row	GB
3rd row	GB

Common Values

Value	Count	Frequency (%)
GB	3	< 0.1%
(Missing)	82252	> 99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gb	3	100.0%

Most occurring characters

Value	Count	Frequency (%)
G	3	50.0%
B	3	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	3	50.0%
B	3	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	3	50.0%
B	3	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	3	50.0%
B	3	50.0%

ol_TaxRate
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

20.0	7731
0.0	460

Length

Max length	4
Median length	4
Mean length	3.9438408
Min length	3

Characters and Unicode

Total characters	32304
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20.0
2nd row	20.0
3rd row	20.0
4th row	20.0
5th row	20.0

Common Values

Value	Count	Frequency (%)
20.0	7731	9.4%
0.0	460	0.6%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
20.0	7731	94.4%
0.0	460	5.6%

Most occurring characters

Value	Count	Frequency (%)
0	16382	50.7%
.	8191	25.4%
2	7731	23.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24113	74.6%
Other Punctuation	8191	25.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16382	67.9%
2	7731	32.1%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	32304	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16382	50.7%
.	8191	25.4%
2	7731	23.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32304	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16382	50.7%
.	8191	25.4%
2	7731	23.9%

ol_Weight
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	74064
Missing (%)	90.0%
Memory size	642.7 KiB

0.0	5611
0.01	2577
0.1	3

Length

Max length	4
Median length	3
Mean length	3.3146136
Min length	3

Characters and Unicode

Total characters	27150
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.01
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	5611	6.8%
0.01	2577	3.1%
0.1	3	< 0.1%
(Missing)	74064	90.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	5611	68.5%
0.01	2577	31.5%
0.1	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	16379	60.3%
.	8191	30.2%
1	2580	9.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18959	69.8%
Other Punctuation	8191	30.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16379	86.4%
1	2580	13.6%

Other Punctuation

Value	Count	Frequency (%)
.	8191	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	27150	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16379	60.3%
.	8191	30.2%
1	2580	9.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16379	60.3%
.	8191	30.2%
1	2580	9.5%

ol_PII
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	642.7 KiB

****	82254

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	329016
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	****
2nd row	****
3rd row	****
4th row	****
5th row	****

Common Values

Value	Count	Frequency (%)
****	82254	> 99.9%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	82254	100.0%

Most occurring characters

Value	Count	Frequency (%)
*	329016	100.0%

Most occurring categories

Value	Count	Frequency (%)
Other Punctuation	329016	100.0%

Most frequent character per category

Other Punctuation

Value	Count	Frequency (%)
*	329016	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	329016	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
*	329016	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	329016	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
*	329016	100.0%

Auto

Heatmap
Table

	RTYPE	SYS_CHANGE_OPERATION	SYS_CHANGE_VERSION	oh_CampaignCode	oh_CustomerID	oh_DeliveryGrossValue	oh_DeliveryNetValue	oh_DeliveryTaxValue	oh_DiscountValue	oh_LastActionCode	oh_NetOrderValue	oh_OrderGrossValue	oh_OrderID	oh_OrderMajorStatus	oh_OrderMinorStatus	oh_OrderType	oh_OrderValuePaid	oh_OrderValueRefunded	oh_PaymentMethod	oh_ShippingCode	oh_SourceCode	oh_TaxValue	ol_AmountPaid	ol_AmountRefunded	ol_CampaignCode	ol_CustomerID	ol_DiscountValue	ol_GrossValue	ol_InvoiceNumber	ol_ItemCostPrice	ol_ItemUnitPrice	ol_LastActionCode	ol_LineID	ol_LineMajorStatus	ol_LineMinorStatus	ol_NetAmount	ol_OrderID	ol_PaymentMajorStatus	ol_PaymentMethod	ol_Quantity	ol_QuantityDespatched	ol_ShippingCode	ol_SkuStatus	ol_SkuStockStatus	ol_SourceCode	ol_TaxRate	ol_TaxValue	ol_Weight
RTYPE	1.000	1.000	NaN	1.000	NaN	1.000	1.000	1.000	NaN	1.000	NaN	NaN	NaN	1.000	1.000	1.000	NaN	NaN	1.000	1.000	1.000	NaN	NaN	NaN	1.000	NaN	NaN	NaN	NaN	NaN	NaN	1.000	NaN	1.000	1.000	NaN	NaN	1.000	1.000	1.000	NaN	1.000	1.000	1.000	1.000	1.000	NaN	1.000
SYS_CHANGE_OPERATION	1.000	1.000	NaN	0.084	NaN	1.000	1.000	1.000	NaN	0.816	NaN	NaN	NaN	0.502	0.028	1.000	NaN	0.950	1.000	0.137	0.130	NaN	NaN	0.026	0.084	NaN	NaN	NaN	NaN	NaN	NaN	0.614	NaN	0.513	0.592	NaN	NaN	0.544	1.000	1.000	NaN	0.776	1.000	1.000	0.130	1.000	NaN	1.000
SYS_CHANGE_VERSION	NaN	NaN	1.000	0.129	-0.058	0.074	0.065	0.074	-0.045	0.168	0.031	0.029	0.145	0.078	0.072	0.056	0.029	0.021	0.137	0.128	0.185	0.017	0.024	0.026	0.129	-0.058	-0.041	0.026	0.152	-0.046	0.023	0.187	0.008	0.153	0.147	0.028	0.145	0.111	0.137	0.000	0.009	0.654	0.000	0.022	0.185	0.049	0.017	0.045
oh_CampaignCode	1.000	0.084	0.129	1.000	-0.038	0.217	0.447	0.211	0.000	0.098	-0.011	-0.008	0.020	0.038	0.014	0.000	-0.009	0.094	0.619	0.745	0.746	0.007	0.000	-0.038	1.000	-0.038	0.003	-0.021	0.014	0.005	-0.021	0.193	0.015	0.035	0.113	-0.026	0.020	0.026	0.619	0.000	0.007	0.066	0.016	0.035	0.746	0.214	0.013	0.019
oh_CustomerID	NaN	NaN	-0.058	-0.038	1.000	0.083	0.072	0.082	0.038	0.087	-0.160	-0.161	0.020	0.081	0.084	0.000	-0.160	-0.111	0.062	0.111	0.057	-0.174	-0.129	-0.028	0.055	1.000	0.010	-0.128	0.026	-0.019	-0.123	0.059	0.000	0.044	0.022	-0.125	0.020	0.011	0.062	0.000	-0.005	0.699	0.095	0.049	0.057	0.056	-0.139	0.104
oh_DeliveryGrossValue	1.000	1.000	0.074	0.217	0.083	1.000	1.000	0.998	-0.003	0.250	-0.222	-0.222	0.037	0.011	0.033	0.025	-0.221	-0.182	0.026	0.537	0.064	-0.214	-0.099	-0.046	0.217	0.029	0.007	-0.096	0.044	-0.019	-0.133	0.132	-0.184	0.048	0.053	-0.095	0.037	0.050	0.026	0.000	-0.012	0.000	0.128	0.052	0.064	0.000	-0.084	0.026
oh_DeliveryNetValue	1.000	1.000	0.065	0.447	0.072	1.000	1.000	1.000	-0.003	0.250	-0.221	-0.222	0.037	0.000	0.031	0.023	-0.221	-0.182	0.277	0.680	0.063	-0.214	-0.099	-0.046	0.447	0.029	0.007	-0.096	0.044	-0.019	-0.133	0.145	-0.184	0.040	0.053	-0.095	0.037	0.050	0.277	0.000	-0.012	0.000	0.129	0.051	0.063	0.072	-0.085	0.028
oh_DeliveryTaxValue	1.000	1.000	0.074	0.211	0.082	0.998	1.000	1.000	-0.002	0.250	-0.225	-0.225	0.037	0.011	0.033	0.025	-0.224	-0.179	0.019	0.533	0.063	-0.211	-0.096	-0.046	0.211	0.029	0.007	-0.098	0.044	-0.019	-0.135	0.130	-0.182	0.048	0.053	-0.097	0.037	0.050	0.019	0.000	-0.012	0.000	0.129	0.052	0.063	0.013	-0.083	0.027
oh_DiscountValue	NaN	NaN	-0.045	0.000	0.038	-0.003	-0.003	-0.002	1.000	0.000	0.090	0.094	-0.228	0.000	0.041	0.000	0.093	0.082	0.000	0.413	0.137	0.111	0.025	0.050	0.018	0.038	0.701	0.023	-0.225	0.023	0.068	0.118	0.076	0.036	0.000	0.021	-0.228	0.006	0.000	0.048	-0.007	0.175	0.018	0.024	0.137	0.025	0.034	0.018
oh_LastActionCode	1.000	0.816	0.168	0.098	0.087	0.250	0.250	0.250	0.000	1.000	0.017	0.013	0.037	0.599	0.351	0.000	0.021	-0.036	0.111	0.298	0.191	-0.083	-0.020	-0.012	0.098	0.014	-0.059	-0.013	0.044	-0.010	-0.025	0.570	0.012	0.242	0.394	-0.007	0.037	0.640	0.111	0.130	0.068	1.000	0.000	0.174	0.191	0.207	-0.043	0.000
oh_NetOrderValue	NaN	NaN	0.031	-0.011	-0.160	-0.222	-0.221	-0.225	0.090	0.017	1.000	0.998	-0.003	0.124	0.284	0.080	0.996	0.651	0.000	0.419	0.127	0.895	0.298	0.208	0.089	-0.160	0.077	0.302	0.014	0.023	0.309	0.146	0.441	0.043	0.042	0.303	-0.003	0.050	0.000	0.077	0.039	0.147	0.166	0.054	0.127	0.056	0.281	0.147
oh_OrderGrossValue	NaN	NaN	0.029	-0.008	-0.161	-0.222	-0.222	-0.225	0.094	0.013	0.998	1.000	-0.000	0.124	0.284	0.078	0.998	0.662	0.000	0.419	0.126	0.915	0.304	0.222	0.087	-0.161	0.079	0.307	0.017	0.024	0.314	0.147	0.436	0.048	0.039	0.306	-0.000	0.047	0.000	0.078	0.037	0.267	0.162	0.057	0.126	0.034	0.295	0.145
oh_OrderID	NaN	NaN	0.145	0.020	0.020	0.037	0.037	0.037	-0.228	0.037	-0.003	-0.000	1.000	0.095	0.000	0.000	-0.002	0.032	0.000	0.031	0.028	0.011	0.061	0.155	0.000	0.020	-0.146	0.065	0.967	-0.088	0.051	0.154	-0.094	0.132	0.315	0.067	1.000	0.258	0.000	0.000	-0.028	0.360	0.000	0.000	0.028	0.000	0.064	0.000
oh_OrderMajorStatus	1.000	0.502	0.078	0.038	0.081	0.011	0.000	0.011	0.000	0.599	0.124	0.124	0.095	1.000	0.726	0.000	0.027	-0.374	0.204	0.071	0.063	0.050	0.008	0.019	0.038	-0.028	-0.018	0.007	0.015	-0.005	0.007	0.362	0.030	0.673	0.662	0.006	0.043	0.558	0.204	0.000	-0.094	0.278	0.000	0.279	0.063	0.053	0.020	0.000
oh_OrderMinorStatus	1.000	0.028	0.072	0.014	0.084	0.033	0.031	0.033	0.041	0.351	0.284	0.284	0.000	0.726	1.000	0.000	0.055	0.006	0.000	0.018	0.018	0.091	0.010	0.041	0.014	-0.059	0.023	0.049	0.019	-0.006	0.048	0.227	0.033	0.794	0.576	0.048	0.056	0.036	0.000	0.000	-0.171	0.000	0.017	0.384	0.018	0.012	0.051	0.017
oh_OrderType	1.000	1.000	0.056	0.000	0.000	0.025	0.023	0.025	0.000	0.000	0.080	0.078	0.000	0.000	0.000	1.000	-0.120	-0.098	0.000	0.323	0.324	-0.106	-0.038	-0.041	0.000	0.002	-0.016	-0.039	-0.120	-0.007	-0.038	0.047	-0.052	0.021	0.019	-0.040	0.061	0.000	0.000	0.000	-0.004	1.000	0.028	0.000	0.324	0.011	-0.034	0.034
oh_OrderValuePaid	NaN	NaN	0.029	-0.009	-0.160	-0.221	-0.221	-0.224	0.093	0.021	0.996	0.998	-0.002	0.027	0.055	-0.120	1.000	0.664	0.000	0.419	0.125	0.912	0.305	0.222	0.088	-0.160	0.079	0.306	0.016	0.024	0.313	0.144	0.435	0.047	0.038	0.305	-0.002	0.047	0.000	0.079	0.052	0.267	0.162	0.056	0.125	0.035	0.294	0.144
oh_OrderValueRefunded	NaN	0.950	0.021	0.094	-0.111	-0.182	-0.182	-0.179	0.082	-0.036	0.651	0.662	0.032	-0.374	0.006	-0.098	0.664	1.000	0.024	0.313	0.053	0.684	0.268	0.341	0.069	-0.111	0.074	0.260	0.046	-0.003	0.266	0.176	0.223	0.176	0.201	0.256	0.032	0.278	0.024	0.061	0.043	0.133	0.102	0.142	0.053	0.100	0.287	0.089
oh_PaymentMethod	1.000	1.000	0.137	0.619	0.062	0.026	0.277	0.019	0.000	0.111	0.000	0.000	0.000	0.204	0.000	0.000	0.000	0.024	1.000	0.620	0.518	0.070	0.002	-0.004	0.619	-0.068	0.010	-0.020	0.016	-0.017	-0.017	0.168	0.040	0.122	0.000	-0.028	0.016	0.000	1.000	0.000	-0.000	0.000	0.003	0.028	0.518	0.183	0.044	0.013
oh_ShippingCode	1.000	0.137	0.128	0.745	0.111	0.537	0.680	0.533	0.413	0.298	0.419	0.419	0.031	0.071	0.018	0.323	0.419	0.313	0.620	1.000	0.707	0.014	0.008	-0.016	0.745	0.012	0.032	0.005	-0.069	-0.001	0.013	0.219	0.057	0.057	0.101	0.005	-0.081	0.049	0.620	0.000	-0.000	0.469	0.045	0.052	0.707	0.224	0.001	0.040
oh_SourceCode	1.000	0.130	0.185	0.746	0.057	0.064	0.063	0.063	0.137	0.191	0.127	0.126	0.028	0.063	0.018	0.324	0.125	0.053	0.518	0.707	1.000	0.062	0.020	0.078	0.746	0.010	-0.082	0.019	-0.011	-0.012	0.010	0.314	0.007	0.055	0.105	0.019	-0.048	0.026	0.518	0.000	-0.003	0.055	0.028	0.044	1.000	0.208	0.024	0.037
oh_TaxValue	NaN	NaN	0.017	0.007	-0.174	-0.214	-0.214	-0.211	0.111	-0.083	0.895	0.915	0.011	0.050	0.091	-0.106	0.912	0.684	0.070	0.014	0.062	1.000	0.319	0.291	0.084	-0.174	0.089	0.318	0.025	0.030	0.326	0.142	0.357	0.053	0.025	0.308	0.011	0.031	0.021	0.085	0.023	0.094	0.147	0.066	0.127	0.152	0.374	0.130
ol_AmountPaid	NaN	NaN	0.024	0.000	-0.129	-0.099	-0.099	-0.096	0.025	-0.020	0.298	0.304	0.061	0.008	0.010	-0.038	0.305	0.268	0.002	0.008	0.020	0.319	1.000	1.000	0.052	-0.129	0.180	0.987	0.070	0.037	0.977	0.099	-0.355	0.300	0.132	0.985	0.061	0.173	0.052	0.095	0.099	0.730	0.655	0.419	0.065	0.187	0.960	0.543
ol_AmountRefunded	NaN	0.026	0.026	-0.038	-0.028	-0.046	-0.046	-0.046	0.050	-0.012	0.208	0.222	0.155	0.019	0.041	-0.041	0.222	0.341	-0.004	-0.016	0.078	0.291	1.000	1.000	0.010	-0.028	0.096	0.999	0.158	0.011	0.974	0.049	-0.137	0.000	1.000	0.996	0.155	1.000	0.026	0.109	0.080	0.364	0.069	1.000	0.091	0.397	0.990	0.000
ol_CampaignCode	1.000	0.084	0.129	1.000	0.055	0.217	0.447	0.211	0.018	0.098	0.089	0.087	0.000	0.038	0.014	0.000	0.088	0.069	0.619	0.745	0.746	0.084	0.052	0.010	1.000	-0.038	0.003	-0.021	0.014	0.005	-0.021	0.193	0.015	0.035	0.113	-0.026	0.020	0.026	0.619	0.000	0.007	0.066	0.016	0.035	0.746	0.214	0.013	0.019
ol_CustomerID	NaN	NaN	-0.058	-0.038	1.000	0.029	0.029	0.029	0.038	0.014	-0.160	-0.161	0.020	-0.028	-0.059	0.002	-0.160	-0.111	-0.068	0.012	0.010	-0.174	-0.129	-0.028	-0.038	1.000	0.010	-0.128	0.026	-0.019	-0.123	0.059	0.000	0.044	0.022	-0.125	0.020	0.011	0.062	0.000	-0.005	0.699	0.095	0.049	0.057	0.056	-0.139	0.104
ol_DiscountValue	NaN	NaN	-0.041	0.003	0.010	0.007	0.007	0.007	0.701	-0.059	0.077	0.079	-0.146	-0.018	0.023	-0.016	0.079	0.074	0.010	0.032	-0.082	0.089	0.180	0.096	0.003	0.010	1.000	0.177	-0.145	0.038	0.237	0.000	-0.031	0.050	0.000	0.175	-0.146	0.000	0.000	0.180	0.004	0.000	0.098	0.072	0.078	0.033	0.179	0.092
ol_GrossValue	NaN	NaN	0.026	-0.021	-0.128	-0.096	-0.096	-0.098	0.023	-0.013	0.302	0.307	0.065	0.007	0.049	-0.039	0.306	0.260	-0.020	0.005	0.019	0.318	0.987	0.999	-0.021	-0.128	0.177	1.000	0.067	0.036	0.990	0.071	-0.361	0.304	0.132	0.999	0.065	0.162	0.063	0.095	0.046	0.730	0.660	0.426	0.071	0.185	0.967	0.549
ol_InvoiceNumber	NaN	NaN	0.152	0.014	0.026	0.044	0.044	0.044	-0.225	0.044	0.014	0.017	0.967	0.015	0.019	-0.120	0.016	0.046	0.016	-0.069	-0.011	0.025	0.070	0.158	0.014	0.026	-0.145	0.067	1.000	-0.097	0.053	0.140	-0.084	0.180	0.444	0.069	0.967	0.353	0.000	0.000	0.003	0.675	0.000	0.170	0.134	0.019	0.065	0.000
ol_ItemCostPrice	NaN	NaN	-0.046	0.005	-0.019	-0.019	-0.019	-0.019	0.023	-0.010	0.023	0.024	-0.088	-0.005	-0.006	-0.007	0.024	-0.003	-0.017	-0.001	-0.012	0.030	0.037	0.011	0.005	-0.019	0.038	0.036	-0.097	1.000	0.035	0.253	0.118	0.000	0.000	0.036	-0.088	0.000	0.026	0.000	-0.019	0.000	0.019	0.014	0.054	0.000	0.037	0.016
ol_ItemUnitPrice	NaN	NaN	0.023	-0.021	-0.123	-0.133	-0.133	-0.135	0.068	-0.025	0.309	0.314	0.051	0.007	0.048	-0.038	0.313	0.266	-0.017	0.013	0.010	0.326	0.977	0.974	-0.021	-0.123	0.237	0.990	0.053	0.035	1.000	0.071	-0.333	0.304	0.130	0.989	0.051	0.161	0.060	0.000	-0.011	0.730	0.650	0.426	0.070	0.185	0.956	0.551
ol_LastActionCode	1.000	0.614	0.187	0.193	0.059	0.132	0.145	0.130	0.118	0.570	0.146	0.147	0.154	0.362	0.227	0.047	0.144	0.176	0.168	0.219	0.314	0.142	0.099	0.049	0.193	0.059	0.000	0.071	0.140	0.253	0.071	1.000	0.239	0.815	0.149	-0.112	0.384	0.798	0.168	0.000	0.137	0.424	0.333	1.000	0.314	0.135	-0.104	0.314
ol_LineID	NaN	NaN	0.008	0.015	0.000	-0.184	-0.184	-0.182	0.076	0.012	0.441	0.436	-0.094	0.030	0.033	-0.052	0.435	0.223	0.040	0.057	0.007	0.357	-0.355	-0.137	0.015	0.000	-0.031	-0.361	-0.084	0.118	-0.333	0.239	1.000	0.146	0.040	-0.360	-0.094	0.062	0.021	0.068	0.015	0.602	0.224	0.205	0.068	0.073	-0.357	0.262
ol_LineMajorStatus	1.000	0.513	0.153	0.035	0.044	0.048	0.040	0.048	0.036	0.242	0.043	0.048	0.132	0.673	0.794	0.021	0.047	0.176	0.122	0.057	0.055	0.053	0.300	0.000	0.035	0.044	0.050	0.304	0.180	0.000	0.304	0.815	0.146	1.000	0.817	-0.554	-0.011	0.806	0.122	0.016	-0.027	0.230	0.449	0.969	0.055	0.070	-0.540	0.426
ol_LineMinorStatus	1.000	0.592	0.147	0.113	0.022	0.053	0.053	0.053	0.000	0.394	0.042	0.039	0.315	0.662	0.576	0.019	0.038	0.201	0.000	0.101	0.105	0.025	0.132	1.000	0.113	0.022	0.000	0.132	0.444	0.000	0.130	0.149	0.040	0.817	1.000	0.276	0.045	0.998	0.000	0.000	0.007	0.688	0.180	1.000	0.105	0.111	0.272	0.500
ol_NetAmount	NaN	NaN	0.028	-0.026	-0.125	-0.095	-0.095	-0.097	0.021	-0.007	0.303	0.306	0.067	0.006	0.048	-0.040	0.305	0.256	-0.028	0.005	0.019	0.308	0.985	0.996	-0.026	-0.125	0.175	0.999	0.069	0.036	0.989	-0.112	-0.360	-0.554	0.276	1.000	0.067	0.155	0.106	0.090	0.049	0.679	0.751	0.414	0.120	0.126	0.957	0.530
ol_OrderID	NaN	NaN	0.145	0.020	0.020	0.037	0.037	0.037	-0.228	0.037	-0.003	-0.000	1.000	0.043	0.056	0.061	-0.002	0.032	0.016	-0.081	-0.048	0.011	0.061	0.155	0.020	0.020	-0.146	0.065	0.967	-0.088	0.051	0.384	-0.094	-0.011	0.045	0.067	1.000	0.258	0.000	0.000	-0.028	0.360	0.000	0.000	0.028	0.000	0.064	0.000
ol_PaymentMajorStatus	1.000	0.544	0.111	0.026	0.011	0.050	0.050	0.050	0.006	0.640	0.050	0.047	0.258	0.558	0.036	0.000	0.047	0.278	0.000	0.049	0.026	0.031	0.173	1.000	0.026	0.011	0.000	0.162	0.353	0.000	0.161	0.798	0.062	0.806	0.998	0.155	0.258	1.000	0.000	0.000	0.046	0.246	0.164	0.934	0.026	0.108	0.269	0.000
ol_PaymentMethod	1.000	1.000	0.137	0.619	0.062	0.026	0.277	0.019	0.000	0.111	0.000	0.000	0.000	0.204	0.000	0.000	0.000	0.024	1.000	0.620	0.518	0.021	0.052	0.026	0.619	0.062	0.000	0.063	0.000	0.026	0.060	0.168	0.021	0.122	0.000	0.106	0.000	0.000	1.000	0.000	-0.000	0.000	0.003	0.028	0.518	0.183	0.044	0.013
ol_Quantity	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.048	0.130	0.077	0.078	0.000	0.000	0.000	0.000	0.079	0.061	0.000	0.000	0.000	0.085	0.095	0.109	0.000	0.000	0.180	0.095	0.000	0.000	0.000	0.000	0.068	0.016	0.000	0.090	0.000	0.000	0.000	1.000	0.830	1.000	0.035	0.025	0.000	0.030	0.058	0.033
ol_QuantityDespatched	NaN	NaN	0.009	0.007	-0.005	-0.012	-0.012	-0.012	-0.007	0.068	0.039	0.037	-0.028	-0.094	-0.171	-0.004	0.052	0.043	-0.000	-0.000	-0.003	0.023	0.099	0.080	0.007	-0.005	0.004	0.046	0.003	-0.019	-0.011	0.137	0.015	-0.027	0.007	0.049	-0.028	0.046	-0.000	0.830	1.000	1.000	0.042	0.401	0.000	0.031	0.030	0.039
ol_ShippingCode	1.000	0.776	0.654	0.066	0.699	0.000	0.000	0.000	0.175	1.000	0.147	0.267	0.360	0.278	0.000	1.000	0.267	0.133	0.000	0.469	0.055	0.094	0.730	0.364	0.066	0.699	0.000	0.730	0.675	0.000	0.730	0.424	0.602	0.230	0.688	0.679	0.360	0.246	0.000	1.000	1.000	1.000	0.692	0.167	0.055	0.675	-0.033	0.000
ol_SkuStatus	1.000	1.000	0.000	0.016	0.095	0.128	0.129	0.129	0.018	0.000	0.166	0.162	0.000	0.000	0.017	0.028	0.162	0.102	0.003	0.045	0.028	0.147	0.655	0.069	0.016	0.095	0.098	0.660	0.000	0.019	0.650	0.333	0.224	0.449	0.180	0.751	0.000	0.164	0.003	0.035	0.042	0.692	1.000	0.443	0.028	0.179	-0.765	0.669
ol_SkuStockStatus	1.000	1.000	0.022	0.035	0.049	0.052	0.051	0.052	0.024	0.174	0.054	0.057	0.000	0.279	0.384	0.000	0.056	0.142	0.028	0.052	0.044	0.066	0.419	1.000	0.035	0.049	0.072	0.426	0.170	0.014	0.426	1.000	0.205	0.969	1.000	0.414	0.000	0.934	0.028	0.025	0.401	0.167	0.443	1.000	0.044	0.018	-0.577	0.421
ol_SourceCode	1.000	0.130	0.185	0.746	0.057	0.064	0.063	0.063	0.137	0.191	0.127	0.126	0.028	0.063	0.018	0.324	0.125	0.053	0.518	0.707	1.000	0.127	0.065	0.091	0.746	0.057	0.078	0.071	0.134	0.054	0.070	0.314	0.068	0.055	0.105	0.120	0.028	0.026	0.518	0.000	0.000	0.055	0.028	0.044	1.000	0.208	0.024	0.037
ol_TaxRate	1.000	1.000	0.049	0.214	0.056	0.000	0.072	0.013	0.025	0.207	0.056	0.034	0.000	0.053	0.012	0.011	0.035	0.100	0.183	0.224	0.208	0.152	0.187	0.397	0.214	0.056	0.033	0.185	0.019	0.000	0.185	0.135	0.073	0.070	0.111	0.126	0.000	0.108	0.183	0.030	0.031	0.675	0.179	0.018	0.208	1.000	0.273	0.165
ol_TaxValue	NaN	NaN	0.017	0.013	-0.139	-0.084	-0.085	-0.083	0.034	-0.043	0.281	0.295	0.064	0.020	0.051	-0.034	0.294	0.287	0.044	0.001	0.024	0.374	0.960	0.990	0.013	-0.139	0.179	0.967	0.065	0.037	0.956	-0.104	-0.357	-0.540	0.272	0.957	0.064	0.269	0.044	0.058	0.030	-0.033	-0.765	-0.577	0.024	0.273	1.000	0.518
ol_Weight	1.000	1.000	0.045	0.019	0.104	0.026	0.028	0.027	0.018	0.000	0.147	0.145	0.000	0.000	0.017	0.034	0.144	0.089	0.013	0.040	0.037	0.130	0.543	0.000	0.019	0.104	0.092	0.549	0.000	0.016	0.551	0.314	0.262	0.426	0.500	0.530	0.000	0.000	0.013	0.033	0.039	0.000	0.669	0.421	0.037	0.165	0.518	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	RTYPE	SYS_CHANGE_VERSION	SYS_CHANGE_OPERATION	oh_ClientCode	oh_OrderID	oh_ExternalOrderID	oh_CustomerID	oh_CampaignCode	oh_SourceCode	oh_MediaID	oh_PaymentMethod	oh_PaymentType	oh_NetOrderValue	oh_TaxValue	oh_OrderGrossValue	oh_OrderValuePaid	oh_OrderValueRefunded	oh_DeliveryReasonCode	oh_DiscountReasonCode	oh_OrderMethod	oh_OrderMajorStatus	oh_OrderMinorStatus	oh_CreatedDate	oh_DespatchDate	oh_CancelledDate	oh_UserID	oh_CurrencyCode	oh_CurrencyRate	oh_LastActionCode	oh_DueDate	oh_DeliverByDate	oh_ShippingCode	oh_ShippingReasonCode	oh_PII	ol_ClientCode	ol_OrderID	ol_ExternalOrderID	ol_CustomerID	ol_LineID	ol_CreatedDate	ol_CampaignCode	ol_SourceCode	ol_MediaID	olProductID	ol_Quantity	ol_QuantityDespatched	ol_DespatchedDate	ol_LineMajorStatus	ol_LineMinorStatus	ol_SkuStatus	ol_SkuStockStatus	ol_PaymentMajorStatus	ol_PaymentMinorStatus	ol_PaymentMethod	ol_PaymentType	ol_CancelledDate	ol_LastActionCode	ol_UserID	ol_CurrencyCode	ol_CurrencyRate	ol_ShippingCode	ol_InvoiceNumber	ol_ItemUnitPrice	ol_NetAmount	ol_TaxValue	ol_GrossValue	ol_AmountPaid	ol_AmountRefunded	ol_PostageValue	ol_PostageTaxValue	ol_PostageReasonCode	ol_DiscountReasonCode	ol_TaxLocale	ol_TaxRate	ol_Weight	ol_PII
0	H	10602.0	U	CRW	5421459.0	12841488	24432924.0	WEBT	WEB	NaN	2.0	NaN	25.00	5.00	30.0	30.0	30.0	NaN	NaN	5.0	Despatch Confirmed	None	2022-10-12 11:22:12.000	NaN	NaN	1000.0	GBP	1.0	NaN	2022-10-12 11:22:12.000	2022-10-12 11:22:12.000	RMT	NaN	****	CRW	5421459.0	12841488	24432924.0	1.0	2022-10-12 11:33:22.093	WEBT	WEB	NaN	1221290	1.0	1.0	2022-10-13 11:29:20.203	Cancelled	Refund Confirmed	10.0	0.0	Refunded	Complete	2.0	NaN	2023-11-22 12:59:05.327	RFI	1000.0	GBP	1.0	NaN	6360410.0	30.0	25.00	5.00	30.0	30.0	30.0	NaN	NaN	NaN	NaN	NaN	20.0	0.00	****
1	H	10602.0	U	CRW	5421459.0	12841488	24432924.0	WEBT	WEB	NaN	2.0	NaN	25.00	5.00	30.0	30.0	30.0	NaN	NaN	5.0	Despatch Confirmed	None	2022-10-12 11:22:12.000	NaN	NaN	1000.0	GBP	1.0	NaN	2022-10-12 11:22:12.000	2022-10-12 11:22:12.000	RMT	NaN	****	CRW	5421459.0	12841488	24432924.0	2.0	2022-10-12 11:33:22.157	WEBT	WEB	NaN	FRL-999	1.0	1.0	2022-10-13 11:29:20.650	Despatch Confirmed	NaN	9999.0	10.0	NaN	NaN	2.0	NaN	NaN	NaN	1000.0	GBP	1.0	NaN	6360410.0	0.0	0.00	0.00	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.00	****
2	H	13287.0	U	CRW	5864333.0	13158853	23690258.0	WEBT	WEB	NaN	2.0	NaN	30.83	6.17	37.0	37.0	37.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-03-09 23:27:42.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-03-09 23:27:42.000	2023-03-09 23:27:42.000	RMT	NaN	****	CRW	5864333.0	13158853	23690258.0	1.0	2023-03-09 23:42:11.780	WEBT	WEB	NaN	1250824	1.0	1.0	2023-03-10 18:41:18.597	Cancelled	Refund Confirmed	10.0	0.0	Refunded	Complete	2.0	NaN	2023-11-22 16:17:11.283	SAR	1000.0	GBP	1.0	NaN	6888122.0	37.0	30.83	6.17	37.0	37.0	37.0	NaN	NaN	NaN	NaN	NaN	20.0	0.00	****
3	H	13287.0	U	CRW	5864333.0	13158853	23690258.0	WEBT	WEB	NaN	2.0	NaN	30.83	6.17	37.0	37.0	37.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-03-09 23:27:42.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-03-09 23:27:42.000	2023-03-09 23:27:42.000	RMT	NaN	****	CRW	5864333.0	13158853	23690258.0	2.0	2023-03-09 23:42:11.787	WEBT	WEB	NaN	FRL-999	1.0	1.0	2023-03-10 18:41:19.083	Despatch Confirmed	NaN	9999.0	10.0	NaN	NaN	2.0	NaN	NaN	NaN	1000.0	GBP	1.0	NaN	6888122.0	0.0	0.00	0.00	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.01	****
4	H	13958.0	U	CRW	5942595.0	13217192	31653496.0	WEBT	WEB	NaN	2.0	NaN	22.50	4.50	27.0	27.0	0.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-04-08 21:47:44.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-04-08 21:47:44.000	2023-04-08 21:47:44.000	CCDPDND	NaN	****	CRW	5942595.0	13217192	31653496.0	1.0	2023-04-08 22:02:15.970	WEBT	WEB	NaN	1246696	1.0	1.0	2023-04-13 10:48:02.473	Cancelled	Failed Payment Process	10.0	0.0	FailedRefund	NaN	2.0	NaN	2023-11-22 17:52:09.567	RFI	1000.0	GBP	1.0	NaN	6982897.0	8.0	6.67	1.33	8.0	8.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.00	****
5	H	13958.0	U	CRW	5942595.0	13217192	31653496.0	WEBT	WEB	NaN	2.0	NaN	22.50	4.50	27.0	27.0	0.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-04-08 21:47:44.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-04-08 21:47:44.000	2023-04-08 21:47:44.000	CCDPDND	NaN	****	CRW	5942595.0	13217192	31653496.0	2.0	2023-04-08 22:02:15.983	WEBT	WEB	NaN	1255352	1.0	1.0	2023-04-11 08:02:25.197	Despatch Confirmed	Charge Confirmed	10.0	10.0	Charged	Complete	2.0	NaN	NaN	NaN	1000.0	GBP	1.0	NaN	6982897.0	19.0	15.83	3.17	19.0	19.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.00	****
6	H	13958.0	U	CRW	5942595.0	13217192	31653496.0	WEBT	WEB	NaN	2.0	NaN	22.50	4.50	27.0	27.0	0.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-04-08 21:47:44.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-04-08 21:47:44.000	2023-04-08 21:47:44.000	CCDPDND	NaN	****	CRW	5942595.0	13217192	31653496.0	3.0	2023-04-08 22:02:15.987	WEBT	WEB	NaN	INTRO	1.0	1.0	2023-04-11 08:02:26.450	Despatch Confirmed	NaN	9999.0	10.0	NaN	NaN	2.0	NaN	NaN	NaN	1000.0	GBP	1.0	NaN	6982897.0	0.0	0.00	0.00	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.01	****
7	H	13958.0	U	CRW	5942595.0	13217192	31653496.0	WEBT	WEB	NaN	2.0	NaN	22.50	4.50	27.0	27.0	0.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-04-08 21:47:44.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-04-08 21:47:44.000	2023-04-08 21:47:44.000	CCDPDND	NaN	****	CRW	5942595.0	13217192	31653496.0	4.0	2023-04-08 22:02:15.990	WEBT	WEB	NaN	FRL-999	1.0	1.0	2023-04-11 08:02:27.313	Despatch Confirmed	NaN	9999.0	10.0	NaN	NaN	2.0	NaN	NaN	NaN	1000.0	GBP	1.0	NaN	6982897.0	0.0	0.00	0.00	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.01	****
8	H	13566.0	U	CRW	5983878.0	13246474	19145903.0	WEBT	WEB	NaN	2.0	NaN	89.99	18.01	108.0	108.0	0.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-04-30 13:29:48.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-04-30 13:29:48.000	2023-04-30 13:29:48.000	CCHERMSTD	NaN	****	CRW	5983878.0	13246474	19145903.0	1.0	2023-04-30 13:42:28.913	WEBT	WEB	NaN	1167612	1.0	1.0	2023-05-02 15:23:29.000	Swapped	NaN	10.0	0.0	Charged	Complete	2.0	NaN	2023-05-11 11:42:07.973	SI	1000.0	GBP	1.0	NaN	7037174.0	40.0	33.33	6.67	40.0	40.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.00	****
9	H	13566.0	U	CRW	5983878.0	13246474	19145903.0	WEBT	WEB	NaN	2.0	NaN	89.99	18.01	108.0	108.0	0.0	NaN	NaN	5.0	Despatch Confirmed	None	2023-04-30 13:29:48.000	NaN	NaN	1000.0	GBP	1.0	NaN	2023-04-30 13:29:48.000	2023-04-30 13:29:48.000	CCHERMSTD	NaN	****	CRW	5983878.0	13246474	19145903.0	2.0	2023-04-30 13:42:28.923	WEBT	WEB	NaN	1260420	1.0	1.0	2023-05-02 15:23:30.000	Swapped	NaN	10.0	0.0	Charged	Complete	2.0	NaN	2023-05-11 11:44:08.437	SI	1000.0	GBP	1.0	NaN	7037174.0	28.0	23.33	4.67	28.0	28.0	NaN	NaN	NaN	NaN	NaN	NaN	20.0	0.00	****

	RTYPE	SYS_CHANGE_VERSION	SYS_CHANGE_OPERATION	oh_ClientCode	oh_OrderID	oh_ExternalOrderID	oh_CustomerID	oh_CampaignCode	oh_SourceCode	oh_MediaID	oh_PaymentMethod	oh_PaymentType	oh_NetOrderValue	oh_TaxValue	oh_OrderGrossValue	oh_OrderValuePaid	oh_OrderValueRefunded	oh_OrderVoucherValue	oh_DeliveryTaxCode	oh_DeliveryNetValue	oh_DeliveryTaxValue	oh_DeliveryGrossValue	oh_DeliveryReasonCode	oh_DiscountValue	oh_DiscountReasonCode	oh_LoyaltyValue	oh_OrderMethod	oh_OrderType	oh_OrderMajorStatus	oh_OrderMinorStatus	oh_CreatedDate	oh_DespatchDate	oh_CancelledDate	oh_Priority	oh_UserID	oh_CurrencyCode	oh_CurrencyRate	oh_LastActionCode	oh_DueDate	oh_DeliverByDate	oh_ShippingCode	oh_ShippingReasonCode	oh_PII	ol_ClientCode	ol_OrderID	ol_ExternalOrderID	ol_CustomerID	ol_LineID	ol_CreatedDate	ol_CampaignCode	ol_SourceCode	ol_MediaID	olProductID	ol_Quantity	ol_QuantityDespatched	ol_DespatchedDate	ol_LineMajorStatus	ol_LineMinorStatus	ol_SkuStatus	ol_SkuStockStatus	ol_PaymentMajorStatus	ol_PaymentMinorStatus	ol_PaymentMethod	ol_PaymentType	ol_CancelledDate	ol_LastActionCode	ol_ParentItemNumber	ol_Priority	ol_UserID	ol_CurrencyCode	ol_CurrencyRate	ol_ShippingCode	ol_InvoiceNumber	ol_ItemCostPrice	ol_ItemUnitPrice	ol_NetAmount	ol_TaxValue	ol_GrossValue	ol_AmountPaid	ol_AmountRefunded	ol_PostageValue	ol_PostageTaxValue	ol_PostageReasonCode	ol_DiscountValue	ol_DiscountReasonCode	ol_TaxLocale	ol_TaxRate	ol_Weight	ol_PII
82245	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:14:23.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:14:23.000	2023-11-23 17:14:23.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:19.520	WEBT	WEB	NaN	1269102	NaN	NaN	NaN	Ready For Despatch	NaN	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	WEB	NaN	NaN	NaN	****
82246	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:14:23.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:14:23.000	2023-11-23 17:14:23.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:19.527	WEBT	WEB	NaN	FRL-999	NaN	NaN	NaN	Ready For Despatch	Waiting For Other Tender	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82247	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	AW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:15:01.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:15:01.000	2023-11-23 17:15:01.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:24.630	WEBT	AW	NaN	1281204	NaN	NaN	NaN	Ready For Despatch	NaN	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82248	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	AW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:15:01.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:15:01.000	2023-11-23 17:15:01.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:24.637	WEBT	AW	NaN	1188024	NaN	NaN	NaN	Ready For Despatch	NaN	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82249	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	AW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:15:01.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:15:01.000	2023-11-23 17:15:01.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:24.643	WEBT	AW	NaN	1275375	NaN	NaN	NaN	Ready For Despatch	NaN	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82250	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	AW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:15:01.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:15:01.000	2023-11-23 17:15:01.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:24.650	WEBT	AW	NaN	1250439	NaN	NaN	NaN	Ready For Despatch	NaN	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82251	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	AW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:15:01.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:15:01.000	2023-11-23 17:15:01.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:24.657	WEBT	AW	NaN	1279659	NaN	NaN	NaN	Ready For Despatch	NaN	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82252	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	AW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:15:01.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:15:01.000	2023-11-23 17:15:01.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:24.663	WEBT	AW	NaN	INTRO	NaN	NaN	NaN	Ready For Despatch	Waiting For Other Tender	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82253	H	NaN	I	CRW	NaN	NaN	NaN	WEBT	AW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 17:15:01.000	NaN	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 17:15:01.000	2023-11-23 17:15:01.000	RMT	NaN	****	CRW	NaN	NaN	NaN	NaN	2023-11-23 17:23:24.667	WEBT	AW	NaN	FRL-999	NaN	NaN	NaN	Ready For Despatch	Waiting For Other Tender	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****
82254	(82254 rows affected)	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequently occurring

	RTYPE	SYS_CHANGE_VERSION	SYS_CHANGE_OPERATION	oh_ClientCode	oh_OrderID	oh_ExternalOrderID	oh_CustomerID	oh_CampaignCode	oh_SourceCode	oh_MediaID	oh_PaymentMethod	oh_NetOrderValue	oh_TaxValue	oh_OrderGrossValue	oh_OrderValuePaid	oh_OrderValueRefunded	oh_OrderVoucherValue	oh_DeliveryTaxCode	oh_DeliveryNetValue	oh_DeliveryTaxValue	oh_DeliveryGrossValue	oh_DeliveryReasonCode	oh_DiscountValue	oh_DiscountReasonCode	oh_LoyaltyValue	oh_OrderMethod	oh_OrderType	oh_OrderMajorStatus	oh_OrderMinorStatus	oh_CreatedDate	oh_CancelledDate	oh_Priority	oh_UserID	oh_CurrencyCode	oh_CurrencyRate	oh_LastActionCode	oh_DueDate	oh_DeliverByDate	oh_ShippingCode	oh_ShippingReasonCode	oh_PII	ol_ClientCode	ol_OrderID	ol_ExternalOrderID	ol_CustomerID	ol_LineID	ol_CreatedDate	ol_CampaignCode	ol_SourceCode	ol_MediaID	olProductID	ol_Quantity	ol_QuantityDespatched	ol_DespatchedDate	ol_LineMajorStatus	ol_LineMinorStatus	ol_SkuStatus	ol_SkuStockStatus	ol_PaymentMajorStatus	ol_PaymentMinorStatus	ol_PaymentMethod	ol_CancelledDate	ol_LastActionCode	ol_ParentItemNumber	ol_Priority	ol_UserID	ol_CurrencyCode	ol_CurrencyRate	ol_ShippingCode	ol_InvoiceNumber	ol_ItemCostPrice	ol_ItemUnitPrice	ol_NetAmount	ol_TaxValue	ol_GrossValue	ol_AmountPaid	ol_AmountRefunded	ol_DiscountValue	ol_DiscountReasonCode	ol_TaxLocale	ol_TaxRate	ol_Weight	ol_PII	# duplicates
0	H	NaN	I	CRW	NaN	13717718	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 07:19:59.000	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 07:19:59.000	2023-11-23 07:19:59.000	RMT	NaN	****	CRW	NaN	13717718	NaN	NaN	2023-11-23 07:32:43.343	WEBT	WEB	NaN	1251434	NaN	NaN	NaN	Torque Processing	Allocated	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****	2
1	H	NaN	I	CRW	NaN	13717992	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Partialy Despatched	None	2023-11-23 08:17:24.000	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 08:17:24.000	2023-11-23 08:17:24.000	RMT	NaN	****	CRW	NaN	13717992	NaN	NaN	2023-11-23 08:32:30.133	WEBT	WEB	NaN	1167789	NaN	NaN	NaN	Torque Processing	Allocated	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****	2
2	H	NaN	I	CRW	NaN	13718167	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 08:46:02.000	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 08:46:02.000	2023-11-23 08:46:02.000	CCHERMSTD	NaN	****	CRW	NaN	13718167	NaN	NaN	2023-11-23 09:02:22.020	WEBT	WEB	NaN	1164964	NaN	NaN	NaN	Torque Processing	Allocated	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****	2
3	H	NaN	I	CRW	NaN	13719369	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 12:32:35.000	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 12:32:35.000	2023-11-23 12:32:35.000	CCHERMSTD	NaN	****	CRW	NaN	13719369	NaN	NaN	2023-11-23 12:43:49.107	WEBT	WEB	NaN	1274880	NaN	NaN	NaN	Ship from Store Processing	NaN	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****	2
4	H	NaN	I	CRW	NaN	13720304	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 15:43:52.000	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 15:43:52.000	2023-11-23 15:43:52.000	RMT	NaN	****	CRW	NaN	13720304	NaN	NaN	2023-11-23 15:53:10.233	WEBT	WEB	NaN	1278399	NaN	NaN	NaN	Torque Processing	Allocated	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****	2
5	H	NaN	I	CRW	NaN	13720375	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN	NaN	PGR	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 15:59:57.000	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 15:59:57.000	2023-11-23 15:59:57.000	CCHERMSTD	NaN	****	CRW	NaN	13720375	NaN	NaN	2023-11-23 16:12:41.943	WEBT	WEB	NaN	1269082	NaN	NaN	NaN	Torque Processing	Allocated	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****	2
6	H	NaN	I	CRW	NaN	13720524	NaN	WEBT	WEB	NaN	NaN	NaN	NaN	NaN	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Ready For Despatch	None	2023-11-23 16:32:42.000	NaN	NaN	NaN	GBP	NaN	NaN	2023-11-23 16:32:42.000	2023-11-23 16:32:42.000	RMT	NaN	****	CRW	NaN	13720524	NaN	NaN	2023-11-23 16:43:16.080	WEBT	WEB	NaN	1278237	NaN	NaN	NaN	Torque Processing	Allocated	NaN	NaN	Authed	Complete	NaN	NaN	NaN	NaN	NaN	NaN	GBP	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	****	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number